csv import url's for image

i cannot seem to get it grab images from url, my distributor has 282k worth of products, all of which that i distribute. its over 2tb worth of images, i can manually complete this process by pasting the link under the add images, but it only loads the name when i use the csv, honestly, 99% of all software offer the option to use a url, even though the process can be achieved manually, i would love someone to show me a way to automate this. please and thank you. also kudos to the devs on a great cart, by far the most fluid and easy to use ive seen.

Josh

nvm,

using my elite excel skills <---(lol) i was able to create a spreadsheet that automagically creates each filename and concatenates wget and .jpg to the url and dumps to .sh file which can be placed at the /uploads root and ran. if anyone else has a massive inventory and needs a csv solution like this email me at This email address is being protected from spambots. You need JavaScript enabled to view it.

thanks

not so much
it omits the .jpg suffix, no matter what i do
also i need to know how to do multiple images per product
they way i described earlier works just fine, but adding url doesnt work
also i need a way to add an option, id like to be able to see the original price logged in as superuser, i have a formula that calculates my price_value column based on percentage and cost amount id like to be able to add a characteristic that allows me to do this.
thanks in advance

nicolas,

thanks for your response.
ive tried adding via text area, and csv
product_code,images
100003, xxxxxxx.com

and it never works
as far as pricing goes, i have over 300k worth of products so i cannot manipulate every item with a individualized price markup. what i have to do is edit my csv using a formula and another column basically if(e2=<500,e2*1.2,if(e2=>750,e2*1.15, and so on and so forth. this calculate my price markup for me based off of the items cost. what i want is to be able to have an original_price column for the original price of the item and have it only viewable by a superuser, basically it doesnt show up unless admin is viewing it. we are using the shop for our physical location as well and this lets my employees and myself see the markup and profit margin on each item, in the case we need to provide a discount to price match or other discount. thanks again

nicholas,

i need to be able to update the original price just as i would the adjusted price. i need it to update automatically via csv. 100s of 1000s of products i do not have time to enter the original price for all of them. is there a way to get hika to grab via csv?

i dont see the option available in existing products, however it is available when i add a product, i tried importing a csv and that was a no go. i need it to be available with exisitng products

Hi there,

slightly off-topic, but I also would like to factor in the profit margin. I. e. I obtain a CSV file from a wholesale supplier, which in one column contains the B2B price I have to pay for the product (low), and in another column contains the suggested retail price with a certain profit margin (high).

Now, I would like to explicitly specify that profit margin myself, based on the low price I have to pay.

I would like to see such functionality in Hikashop (similar to the formula that is suggested above), or maybe some can suggest a sample pre-processing script (sed, awk?) that factors in that logic.

Also, I am looking for a simple (pre-processor) mechanism for existing products to map product codes from various wholesale suppliers or from the manufacturer to my product codes. That way I would be more flexible in swapping a supplier.

Thanks Nicolas. -- I had a look into awk and coded a simple preprocessor that rearranges the CSV.
Two sample routines quoted below.

best regards

Klaus @hactic


the price logic:

BEGIN {
FS = ";";
UST = 1.19;
datestamp = 0; # TODO $(date '+%d/%b/%Y'); # "'"$(date)"'"}'; # +'%Y-%m-%d %r';
}
{
if("Axis" == $4) {
if($10 < 0) ; # error
else if($10 < 500) price = $10 * UST * 1.15;
else if($10 < 1000) price = $10 * UST * 1.10;
else price = $10 * UST * 1.05;

print "product_code;" $3 ";" $5 ";" $10 ";" price ";" $14 ";" $15 ";" datestamp;
}
}
END {

mapping manufacturer product codes to product_codes in HikaShop:

BEGIN {
FS = ";";

while ( (getline line < "map-axis-smartgart.txt") > 0 ) {
split(line, f);
map[f[1]] = f[2];
}
}
{
product_code = "product_code";
if(map[$2] != "")
product_code = map[$2];
print product_code ";" $2 ";" $3 ";" $4 ";" $5 ";" $6 ";" $7 ";" $8
}
END {

}

map file map-axis-smartgart.txt:

mfr_code,product_code
0543-001;M3007-P
0515-001;M3007-PV
0556-001;M3027-PVE
...