[SOLVED] questions re importing product data CSV

[sunnyb0y]

Hello,

 

I am new to PrestaShop and using 1.5.4 and wanting to import product data for a fruit and veg shop.

 

When I go to the import section at Advanced Parameters > CSV Import, I can see the following fields but I am a bit confused on a few things and would apreciate any help:

• ID
  
• Active (0/1)
  
• Name *
  
• Categories (x,y,z...)
  
• Price tax excluded or Price tax included
  
• Tax rules ID
  
• Wholesale price
  
• On sale (0/1)
  
• Discount amount
  
• Discount percent
  
• Discount from (yyyy-mm-dd)
  
• Discount to (yyyy-mm-dd)
  
• Reference #
  
• Supplier reference #
  
• Supplier
  
• Manufacturer
  
• EAN13
  
• UPC
  
• Ecotax
  
• Weight
  
• Quantity
  
• Short description
  
• Description
  
• Tags (x,y,z...)
  
• Meta title
  
• Meta keywords
  
• Meta description
  
• URL rewritten
  
• Text when in stock
  
• Text when backorder allowed
  
• Available for order (0 = No, 1 = Yes)
  
• Product creation date
  
• Show price (0 = No, 1 = Yes)
  
• Image URLs (x,y,z...)
  
• Delete existing images (0 = No, 1 = Yes)
  
• Feature(Name:Value:Position)
  
• Available online only (0 = No, 1 = Yes)
  
• Condition
  
• ID / Name of shop
  

 

 

0) A number of the columns are not relevant for this shop (eg Supplier, Manufacturer, Wholesale price, Discount amount, Discount percent etc). Do I just leave these blank in the import file?

 

1) ID - Is this something we create (like xy01) or is it something that PrestaShop creates in import? Is it sequential numbers only like in the demo products?

 

2) Price tax excluded or Price tax included

Does this imply you literally use the text "Price tax excluded" in the column where tax is not applicable to a product?

 

3) Where is the main "retail" price column?

 

4) Active (0/1) - Does 1 = active?

 

5) On sale (0/1) - Does 0 = no?

 

6) Categories (x,y,z...) - Does the categories column use the category name or ID? Is one better than the other when importing?

 

7) Reference #

What is this used for? I see in the demo products that come when installing all have demo_ and a number but I am unsure what this is for.

 

8) Image URLs (x,y,z...)

I have the filenames of the images in the csv file and I presume I need to ftp the images to the server:

a. in the csv file do I need to add the full path, and if so, what is it?

I can see the demo ipod images etc are in img/p/1 etc eg img/p/X/bananas.jpg (where X is the product ID)

b. and on the server where do I bulk upload all the images?

 

9) Quantity - we are not using stock levels on this as produce is purchased relative to orders received. Do I make this 0 or blank in the csv file?

 

10) Condition - what are the options? its for fruit and veg so not really relevant. Leave blank?

 

11) Weight - how do your represent 1kg and 500g? as 1 and 0.5??

 

 

Thanks in advance for any help.

[swsindonesia]

0) A number of the columns are not relevant for this shop (eg Supplier, Manufacturer, Wholesale price, Discount amount, Discount percent etc). Do I just leave these blank in the import file?

==> you can just leave them blank

 

1) ID - Is this something we create (like xy01) or is it something that PrestaShop creates in import? Is it sequential numbers only like in the demo products?

==> leave this blank, there's an option for this field later when you import the file

 

2) Price tax excluded or Price tax included

Does this imply you literally use the text "Price tax excluded" in the column where tax is not applicable to a product?

==> this is your final retail price, depends on the tax rule id you provide, it will calculate another retail price if you provide any tax rule id

 

3) Where is the main "retail" price column?

==> see no.2

 

4) Active (0/1) - Does 1 = active?

==> yes, active / enable = 1

 

5) On sale (0/1) - Does 0 = no?

==> yes, 0 means this item is not on sale (special price reduction)

 

6) Categories (x,y,z...) - Does the categories column use the category name or ID? Is one better than the other when importing?

==> category name, x, y, z example -> laptops, accessories, apple

 

7) Reference #

What is this used for? I see in the demo products that come when installing all have demo_ and a number but I am unsure what this is for.

==> this is your SKU number (if any) I don't suppose you need this for fruit and veg

 

8) Image URLs (x,y,z...)

I have the filenames of the images in the csv file and I presume I need to ftp the images to the server:

a. in the csv file do I need to add the full path, and if so, what is it?

I can see the demo ipod images etc are in img/p/1 etc eg img/p/X/bananas.jpg (where X is the product ID)

b. and on the server where do I bulk upload all the images?

==> based on the docs (docs/csv_import/product_import.csv) images should be uploaded somewhere else first, then PS will load them i.e. : http://www.domain.com/temp/images1.jpg

 

9) Quantity - we are not using stock levels on this as produce is purchased relative to orders received. Do I make this 0 or blank in the csv file?

==> set 0, then don't forget to allow order for not in stock product in your Preferences -> Order

 

10) Condition - what are the options? its for fruit and veg so not really relevant. Leave blank?

==> new/used

I assumed nobody would buy any used veg/fruit, just set new

 

11) Weight - how do your represent 1kg and 500g? as 1 and 0.5??

==> weight in kg

 

a little click on the "like this" wouldn't hurt anyone

[sunnyb0y]

Thanks swsindonesia!

 

That was so helpful and I really appreciate it - and nice to have some humour amongst it, I love it.

 

Re the images, ah I see.

 

That pointed me in the right direction -

http://doc.prestashop.com/display/PS15/Understanding+The+Advanced+Parameters#UnderstandingTheAdvancedParameters-CSVImport

 

Given the header matching talked about on that page, does that mean that I don't actually need to include all of those columns from the list in the orginal post?

 

In the csv file, how would you represent items where there are options (like pumpkins: quarter, half or whole etc) with priice differences? Or is that better done manually once imported?

 

Thanks again, your input was awesome.

[PascalVG]

Nice one sws, Like!

[luckyjull]

Hello,

I am also starting with Prestashop and I feel a little bite limited with the few fields I am able to import with CSV Import... How did you get all this long list you have Sunnyb0y?

 

Thanks for your help!

 

ID

Active (0/1)

Name *

Parent category

Root category (0/1)

Description

Meta title

Meta keywords

Meta description

URL rewritten

Image URL

ID / Name of shop

[RogueWaveLimited]

Well, I'm a little late on this but it may have some additional information:

 

0) If you don't need a field, just remove it from the file. Unless it is a required field.

 

1) You should not include the ID field and one will be generated for each product upon import.

 

2) No, you should enter one price or the other then when you import (on the import page) you choose which price you are specifiying with the field

 

3) See answer for "2". this is the price that appears on the product page

 

4) yes

 

5) correct

 

6) actually you can use either the name or the ID. However if the name doesn't exactly match a new category will be created.

 

7) You can specify anything you wish for a reference or you can leave it blank. You can use this as an index to your product (instead of ID) when you update a product.

 

8a& The images don't have to be on the store server (although it is probably MUCH faster if they are there). The images can reside anywhere that you can get to with http, even on some other server. I usually put them in the admin/import directory. the URL is then "http://<storedomain>/<adminDirName>/import/<imageName>.jpg". You can delete them after the import succeeds if you want since PS makes it's own copy.

 

9) I usually set it to 1000. If you set it to zero it will show as out of stock I believe.

 

10) You can leave it out of the file if you don't need it. I think it is designed to be used for feeds to shopping sites like froogle. etc..

 

11) Yes - and you have to set your localization weights to kg.

 

Also you should not include the parens around a category list or an image list. so for example a list of categories in the file would look like this "cata,catb,catc" - not "(cata,catb,catc)".

[sunnyb0y]

Hello luckyjull,

 

You were in the right spot. I had the exact same issue at first too and I was scratching my head looking for price etc.

 

This is how I see all those product related fields...

 

1. Go back to the import section at Advanced Parameters > CSV Import

 

2. Next to the question "What kind of entity would you like to import?" there is a select menu that says "Categories"

(that seems to be the default even though we might be coming directly from the products page via the import button - it would be nice if that was adjusted)

 

3. Choose "Products" from that select menu.

After a slight delay, all available product fields expand in the RHS to match the one at the top of the post.

 

Can you see them now?

[sunnyb0y]

Hi RogueWaveLimited,

 

Thanks for the help, I appreciate the additional info. Never too late to chip in.

 

Re 0) Understood, I just deleted a lot of columns - thanks.

In products "Name *" appears to be the only required field as it is the only one with an asterisk - Does that sound right?

 

Re 6) To avoid typos etc, I will use category ID then - good tip.

 

Re 7) Ah I see, understood.

 

Re 8) Cheers for image info. I will definitely put them on the server in a folder and then delete afterwards. I didn't realise PS makes a copy, that is genius! I get it. Nice one.

 

Re 9) We've got inventory disabled so will now leave this field out of the csv as it appears not relevant.

 

Thanks for confirming re excluding the brackets.

 

Thank you very much.

 

Have a super day!

[swsindonesia]

Thanks swsindonesia!

 

That was so helpful and I really appreciate it - and nice to have some humour amongst it, I love it.

 

Re the images, ah I see.

 

That pointed me in the right direction -

http://doc.prestasho...eters-CSVImport

 

Given the header matching talked about on that page, does that mean that I don't actually need to include all of those columns from the list in the orginal post?

 

In the csv file, how would you represent items where there are options (like pumpkins: quarter, half or whole etc) with priice differences? Or is that better done manually once imported?

 

Thanks again, your input was awesome.

 

Hi, if what you mean by options is Product Combination, I'm afraid you can't use the CSV import.

 

When dealing with this kind of issue, I usually build another module that allows me to import from another data source for each product and SKU, this is very useful and straightforward when dealing with client that already has another product database.

[luckyjull]

Thanks for your answer Sunnyb0y!

 

The solution was just in front of me in fact... !

[sunnyb0y]

Hi, if what you mean by options is Product Combination, I'm afraid you can't use the CSV import.

When dealing with this kind of issue, I usually build another module that allows me to import from another data source for each product and SKU, this is very useful and straightforward when dealing with client that already has another product database.

Ah no worries, thanks for letting me know. There are only 4 or 5 products that have variations so I will adjust them manually after import. Many thanks SWS.

 

Thanks for your answer Sunnyb0y!

The solution was just in front of me in fact... !

Pleasure luckyjull, you were right next to it. Best of luck with the project.

[sunnyb0y]

Thanks for the help with this post.

 

The csv importing was successful for me.

 

Cheers

[swsindonesia]

Thanks for the help with this post.

 

The csv importing was successful for me.

 

Cheers

Glad that helps, please take your time to mark this topic [sOLVED] by editing the topic and add [sOLVED] in the beginning of the subject. It will help other with similar issue too

[SaLiC]

Hi this tread was helpful for my, however, I have a few questions.

 

1. where does the cvs look for the file? I have an csv with 2.000 products, and the img url are already there. So I would love to be able to put the img folders in the same folder as Presta starts looking. Does that make sense? I would make a relative path the url in the csv points at Files/Billeder/konferenceborde/Konferencebord-2.jpg
I made folders with those namings, having the Files folder in the root of presta. (same level as admin, cache, classes and so on.

Shouldnt this be working?

 

2. Also, 1 more problem. In the cvs file, for some reason the filename, is changed to begin with "k" instead of "K". The caps is removed? folders are still with caps, but not the filename. Can I change this? Or is it possible to do something to prevent this before exporting the cvs from db access file?

[SaLiC]

And one more thing, is there a field for setting deny orders when product is out of stock?

[sunnyb0y]

Hi Sara,

 

1. where does the cvs look for the file? I have an csv with 2.000 products, and the img url are already there. So I would love to be able to put the img folders in the same folder as Presta starts looking. Does that make sense? I would make a relative path the url in the csv points at Files/Billeder/konferenceborde/Konferencebord-2.jpg

I made folders with those namings, having the Files folder in the root of presta. (same level as admin, cache, classes and so on.

Shouldnt this be working?

 

2. Also, 1 more problem. In the cvs file, for some reason the filename, is changed to begin with "k" instead of "K". The caps is removed? folders are still with caps, but not the filename. Can I change this? Or is it possible to do something to prevent this before exporting the cvs from db access file?

 

A more experienced user will be able to provide better help but I will try my best.

 

1. Re the image paths in a csv file

 

I was able to successfully import the image names correctly in using this format:

http://yourdomain.com/img/any-temporary-folder-name/image-name.jpg

So I think the full image path actually needs the domain name (eg as if you were typing that url to view the image in your browser), and the images need to be uploaded via ftp to a temporary folder in PrestaShop's "img" folder before importing. Then I think on importing the csv file, PrestaShop grabs those images and puts them into their own folder for each product inside the "img > p" folder - I do not think you can control the names of the final image folders, numbers are used for folder names.

 

I think you should be able to use the path to the images you have uploaded in the files folder in your csv file like so:

http://yourdomain.com/Files/Billeder/konferenceborde/Konferencebord-2.jpg

(make sure the Capitals are correct as it might be case sensitive)

 

If that doesn't work, try moving those images from the files folder to a temporary folder in PrestaShop's img folder.

 

2. I can't answer that sorry, only that PrestaShop sometimes does some wierd things.

Its probably good practice to use lowercase anyway

 

3. Also I am not sure about 3 either. My experience with the csv importing was that not all fields can be imported.

 

Hopefully a more experienced user replies with more info.

 

Good luck with the project.

Edited December 18, 2013 by sunnyb0y (see edit history)

[PascalVG]

And one more thing, is there a field for setting deny orders when product is out of stock?

Hi Sara,

You might consider this:

http://www.prestashop.com/forums/topic/258359-how-to-hide-out-of-stock-products-in-prestashop-1541

 

Read through it all, there are a few options given, so see what works for you(r database).

 

My $0.02,

pascal

[SaLiC]

Thanks.

It seams that in my tables all the urls for img file-names is all changed to lowercase, even though some of them are named in uppercase. I think this is what causes my troubles.. Is there anyway to tell presta not to look at the upper/lower case?

Folders are still beginning with uppercase.

I guess it is the old CMS I where they are exportet from that is the problem.

 

Or maybe I can do something to change all naming to lowercase. Doing this manually will take ages, as I have many photos..

 

For the hide sold products, thanks for the link, but I only need this for some products not all, so probably I should do it manually, what I would like was to set the choice, in product -> quantity -> don't allow orders when out of stock.

Because all the products that I import are limited in quantity.

[Optimus_Sam]

0) A number of the columns are not relevant for this shop (eg Supplier, Manufacturer, Wholesale price, Discount amount, Discount percent etc). Do I just leave these blank in the import file?

==> you can just leave them blank

 

1) ID - Is this something we create (like xy01) or is it something that PrestaShop creates in import? Is it sequential numbers only like in the demo products?

==> leave this blank, there's an option for this field later when you import the file

 

2) Price tax excluded or Price tax included

Does this imply you literally use the text "Price tax excluded" in the column where tax is not applicable to a product?

==> this is your final retail price, depends on the tax rule id you provide, it will calculate another retail price if you provide any tax rule id

 

3) Where is the main "retail" price column?

==> see no.2

 

4) Active (0/1) - Does 1 = active?

==> yes, active / enable = 1

 

5) On sale (0/1) - Does 0 = no?

==> yes, 0 means this item is not on sale (special price reduction)

 

6) Categories (x,y,z...) - Does the categories column use the category name or ID? Is one better than the other when importing?

==> category name, x, y, z example -> laptops, accessories, apple

 

7) Reference #

What is this used for? I see in the demo products that come when installing all have demo_ and a number but I am unsure what this is for.

==> this is your SKU number (if any) I don't suppose you need this for fruit and veg

 

8) Image URLs (x,y,z...)

I have the filenames of the images in the csv file and I presume I need to ftp the images to the server:

a. in the csv file do I need to add the full path, and if so, what is it?

I can see the demo ipod images etc are in img/p/1 etc eg img/p/X/bananas.jpg (where X is the product ID)

b. and on the server where do I bulk upload all the images?

==> based on the docs (docs/csv_import/product_import.csv) images should be uploaded somewhere else first, then PS will load them i.e. : http://www.domain.com/temp/images1.jpg

 

9) Quantity - we are not using stock levels on this as produce is purchased relative to orders received. Do I make this 0 or blank in the csv file?

==> set 0, then don't forget to allow order for not in stock product in your Preferences -> Order

 

10) Condition - what are the options? its for fruit and veg so not really relevant. Leave blank?

==> new/used

I assumed nobody would buy any used veg/fruit, just set new

 

11) Weight - how do your represent 1kg and 500g? as 1 and 0.5??

==> weight in kg

 

a little click on the "like this" wouldn't hurt anyone

Double LIKE!

[Repairwerkz]

Thanks for the post it has been helpful. I am having a problem finding the imported file after it uploads. I am trying to add my imported products to a category. Is that possible? I get the message of a successful upload can not locate file to add products. Please assist.

[Optimus_Sam]

@Repairwerkz:

 

It's just in the dropdown menu dude

 

Yes you can also add products straight into the category. That is possible.

Try looking at this youtube:

 

Sam

[Repairwerkz]

Thanks will configure my items to been seen in presta shop :-)