Is it possible to edit CSV-upload?

I was wondering if it's possible to edit the fields for CSV-upload?

I've got a webshop where my supplier upload a file every morning with products and prices. But the file they upload is not working with Hikashop. This is the fields that appears in the top of the csv-file...

itemID
Qty
ItemOEM
ItemEAN
Item
ItemTxt
ItemWebDescription
Unit
StockActual
ExpectedDate
Price
PriceTaxAndFees
Currency
VatTax
ItemType
Brand
Weight
Volume
Height
Width
Depth
AddFeesTax
CustItemId
CreateDateTime
StatCode
OrigCountry
MinQ
Multiples
Colli
BrandTxt
ItemTypeTxt
NonStockItemTxt
BIDID

It's not every single thing that has to be shown on the webshop or the backend, but is there a guide or something like "How To" to edit the way, the CSV-upload is working? Thanks.

Hi,

My advice would be to, use the "export CSV" option of your "Hikashop->Products" page, to fill and edit this file, and to reupload it through the "Import CSV" option.

Hope this will help you.

Yes I could do that. The problem is, that my supplier uploads a file every morning. This file is automaticly uploaded to Hikashop, so if it's possible, I want to be able just to upload the file and that's it? Thanks.

Hello, this is a similar thread to my question so i will add on...
I have a shop i need to import between 100-1700 item into, i have used the export file to create an upload template which i am then editing to create the items.

Can you let me know why its not loading the images its applying the image as a name and not the actual image.
Cheers this would realy speed this import up

product_id,product_name,product_description,product_code,product_tax_id,product_type,parent_category,categories,images
5000,Walter,This is a bloody test,itm-1000,none,Pen,Walter,Pens,"310.jpg"
5001,Walter,This is a bloody test,itm-1001,none,Pen,Walter,Pens,"312.jpg"
5002,Walter,This is a bloody test,itm-1002,none,Pen,Walter,Pens,"313.jpg"

twhcreations wrote: Hello, this is a similar thread to my question so i will add on...
I have a shop i need to import between 100-1700 item into, i have used the export file to create an upload template which i am then editing to create the items.

Can you let me know why its not loading the images its applying the image as a name and not the actual image.
Cheers this would realy speed this import up

product_id,product_name,product_description,product_code,product_tax_id,product_type,parent_category,categories,images
5000,Walter,This is a bloody test,itm-1000,none,Pen,Walter,Pens,"310.jpg"
5001,Walter,This is a bloody test,itm-1001,none,Pen,Walter,Pens,"312.jpg"
5002,Walter,This is a bloody test,itm-1002,none,Pen,Walter,Pens,"313.jpg"

Oh also can you run through what you need to do to add a variant i have tried to get this to work also but no luck yet.

product_id,product_parent_id,product_name,product_description,product_code,product_type,parent_category,categories,images,,,,,,,,,,,,,,,,,,,,,,,,,,
4000,0,BallPoint Pen,This is a test Item to upload,test-a,main,Walter,Pen,310.jpg,,,,,,,,,,,,,,,,,,,,,,,,,,Blue
4001,4000,Red Pen,Red Pen,test-a1,variant,,,310.jpg,,,,,,,,,,,,,,,,,,,,,,,,,,Red
4002,4000,Blue Pen,Blue Pen,test-a2,variant,,,310.jpg,,,,,,,,,,,,,,,,,,,,,,,,,,Green
4003,4000,Black Pen,Black Pen,test-a3,variant,,,310.jpg,,,,,,,,,,,,,,,,,,,,,,,,,,Blue

yeah i have tried that i have loaded the complete path of the jpg files and it adds them in as a label not the image. its frustrating me at present

Thanks i will be trying this again soon, i did try it with the images in the location you mentioned and i also noticed the main and variant option also.
This has been a really frustrating process, its been a load of trial and error, great feature just not as well documented as i would have liked.