How do I import products and product options with a CSV file?

  • 0
  • 4
  • Question
  • Updated 5 years ago
  • Doesn't Need an Answer
  • (Edited)
Archived and Closed

This conversation is no longer open for comments or replies and is no longer visible to community members. The community moderator provided the following reason for archiving: Archived

Required Fields Creating Products with a CSV requires the following fields:

  • Product ID (must be blank)
  • Product Name (no two can be the same)
  • Category (Category1/Subcategory;Category2;)
  • Price
  • Weight
Updating Existing Products with a CSV requires the following fields:

  • Product ID
  • Product Name
  • Category
Importing a CSV file These steps will only work with a CSV (Comma Separated Value) file using required fields. If you are using an XML file, please convert to CSV before proceeding.

1. Go to Products, then Import Products.

2. Fill out your desired settings under Import Details. The typical settings are displayed below.

  • Bulk Edit Re-Import?: Select this if you exported your products using the Bulk Edit template.
  • Preview this import?: Leave this unchecked for a faster import time.
Import details on Products  Import products

3. Under File Details, select Choose File. You will be prompted to select your CSV file from your computer. The other settings can be left as they are.

File details section which allows you to choose which file you are uploading

4. Click Next.

Next button

5. If you used the Bulk Edit template, all fields will be matched automatically. If not, match each header with the equivalent column header from your CSV. (For example, if your CSV has all product names listed under a column called 'Name', you will match 'Product Name' with 'Name'.)

Not all fields are required for a successful import.


Matching fields section where you see the Product Name field being matched with the equivalent field from your CSV

6. Click Next.

Next button

7. Click Start Import. The import will begin to load.

Import in progress pop-up

8. When the import has finished, you will see a successful import notification along with import details. 

Successful import notification

Creating Options The following option types can be created through a CSV import:

  • Checkbox [CB]
  • Multiple Choice
    • Radio [RB]
    • Select (drop-down)[S]
    • Rectangle [RT]
  • Product List
    • With Photos [PI]
    • Without Photos [P]
  • Color Swatch [CS]
To create these options from your CSV file, add the following line items directly below the product they belong to.

  • Item Type - SKU or Rule (either will work)
  • Product ID - must be blank
  • Product Name* - [Option1Type]OptionName=Value,[Option2Type]Option2Name=Value
  • Option Set - The name of the option set that will contain the options
  • SKU(optional) - If the Item Type is a SKU, you must put a unique SKU
For example, the product name for an option containing a size option (multiple choice rectangle) and a color option (color swatch) would be: [RT]Size=SMALL,[CS]Color=Silver:#cccccc

Some option types will require additional settings. Refer to the sample product CSV, or create one manually and export it to take a look.

Troubleshooting My images aren't showing up!

  • If you are following the steps in this article, make sure that you are using the full image path. If your images are located in your /import folder in WebDAV, keep in mind the names are case-sensitive.
My file is loading slowly or not at all!

  • If your file is large (100mB or more), consider putting it on the import_files folder and selecting Use a file already on the server on Step 3 above.
I imported a file and now all of my categories are gobbledygook!

  • You may have uploaded an XLS or XML file instead of a CSV file. Try deleting the new categories, converting your file to CSV, and importing again.
It says some of my products failed to import!

  • Click on More Details next to the import information. This will let you know if you are missing any required information. Note that you will need to add 1 to any line numbers it provides, since it does not count the header line.
  • More details link and pop-up on a failed upload

The 'More Details' window says "Invalid track inventory value ignored." What does that mean?

  • This means that your Track Inventory column has been left blank instead of having "none" or another value that it can accept. If this happens, the system will show you this error message and just ignore the value (and will not track inventory for the product). This is not a required field and will not cause your CSV file not to import. If your import was not successful, look for a different error that may have been the cause.
  • More Details pop-up with an Invalid tracking inventory value ignored message


Field Descriptions and Values


 Item Type
Product
The Item Type tells our system if the line is a product, rule, or SKU.


Product ID
123
The Product ID is uniquely defined by the database and cannot be created manually. When importing NEW products please disregard this column from the import. If you are re-importing existing products then you can use the already existing product ID provided from the bulk export.


*Product Name
Apple Mighty Mouse
Product name is the unique identifier for the table. This is a required field.


Product Type
P
This will determine whether it will be a physical product that will be shipped to the customer, or a downloadable product made available via download only (such as an eBook).


Product Code/SKU
MIGHTYMOUSE
An optional product code or stock keeping unit (SKU) which is a specific number/bar code used to identify a product. SKUs have to be unique and can NOT be duplicated.


Bin Picking Number
A9283
The Bin Picking Number is usually used for stores who have a warehouse and use a Bin Picking Number to tell where the product is located in the warehouse. It may also be used for determining which warehouse a product will be shipped from, if you have multiple warehouses.


Brand Name
Apple
A brand is the identity of a specific product, typically the manufacturer.


Option Set
Colors
Here you enter the name of the option set you want applied to the product.


Option Set Align
Right
Specify if you want the option set aligned to the right by inserting "Right" or below by inserting "Below".


Product Description

Here is where you can give a text description of your product.


*Price
25.95
The amount it will cost the customer to buy the product from you.


Cost Price
20.00
How much this product cost you to buy. This does not appear on the storefront and is used for internal accounting purposes only, such as within the MYOB export.


Retail Price
25.95
If entered, the retail price will be shown on your site. Generally, it's used to show customers that your product is cheaper than the normal retail price and will be displayed like this:

Retail Price: $25.95
Your Price: $19.95(You Save $6.00)



Sale Price
19.95
If entered, this product will be shown as 'On Sale' and the sale price will replace the usual price for this product (as described above).


Fixed Shipping Cost
15
Fixed shipping is the cost to ship one unit of this product. If left blank, the default shipping calculator will be used during checkout. Please remember that a fixed shipping cost will override any shipping method in your store when this product is purchased.


Free Shipping
N
You can specify here if you want free shipping per product. If not the product will be factored into normal shipping calculations during checkout. (Y=yes N=no)


Product Warranty

You can enter any warranty details for each product into this field.


*Product Weight
0
If you are using a physical product which needs to be fixed, then you must enter a weight for each product(in LBS) so that it can be used to calculate shipping costs when ordering.


*Product Width
0
Some shipping companies require the physical dimensions of a product to calculate shipping charges. If this is the case you can enter the width of this product (in inches) here.


*Product Height
0
Some shipping companies require the physical dimensions of a product to calculate shipping charges. If this is the case you can enter the height of this product (in inches) here.


*Product Depth
0
Some shipping companies require the physical dimensions of a product to calculate shipping charges. If this is the case you can enter the depth of this product (in inches) here.


Allow Purchases?
Y
- This product can be purchased in my online store (Y=yes)
- This product is coming soon but I want to take pre-orders (Y=yes)
- This product cannot be purchased in my online store (N=no)



Product Visible?
Y
Here you can determine if the product should be visible on the storefront. (Y=yes N=no)


Product Availability
Normally ships within...
A few words telling the customer how long it will normally take to ship this product.


Track Inventory
none
Set if you plan on tracking inventory for the product. Options are: none, by product, by option


Current Stock Level
30
Here you can set how many units of the product that are currently in stock.


Low Stock Level
4
You can set the low stock level, and when the product inventory level falls below this number there will be a notification within the control panel informing the store owner.


*Category
Shop Mac/Accessories
Here you can specify the categories and subcategories that each product lives within.


Product Image ID - 1
123
The product image id is uniquely generated by the database, and cannot be created manually. If you have exported pre-existing products then you can import the same product images using the same product image id. If you are importing new products then please disregard this field.


Product Image File - 1
sample.jpg
When importing products you need to upload the images within product_images/import directory via FTP in order to only use the image name. If not, you must place the full url path into the field.


Product Image Description - 1

Give a text description of the image. This will be used to populate the ALT Tag for SEO.


Product Image Is Thumbnail - 1
Y
Use this if you have more than one image being assigned to the product. Set Y for the image that should be the thumbnail, N for the rest.


Product Image Sort - 1
1
When more than one image is assigned use this to set the order that they display. Choose one value (1, 2, 3, 4, etc.), and higher numbers will show up later than lower numbers.


Search Keywords
widget, affordable, portable
The search keywords are optional, but if this field is populated they will be used for two things.
First, they will be used along with the product name to create meta tags for search engines.
Second, they will be used to assist people when searching your products. Enter keywords separated by commas.



Page Title

Here you can specify a page title, or leave blank to use the product's name as the page title.


Meta Keywords

Here you can specify unique meta keywords, or leave blank to use default site wide keywords as defined in the Store Settings page of the control panel.


Meta Description

Here you can specify a unique meta description, or leave blank to use default site wide description as defined in the Store Settings page of the control panel.


MYOB Asset Acct
1-1234
Linked asset account used when a product is inventoried. Must be a valid, pre-existing MYOB account number. 5 characters, numeric. May have an optional non-numeric separator between the first digit and the last 4 digits.


MYOB Income Acct
1-1234
Linked income account used when a product can be sold. Must be a valid, pre-existing MYOB account number. 5 characters, numeric. May have an optional non-numeric separator between the first digit and the last 4 digits.


MYOB Expense Acct
1-1234
Linked expense or cost of sales account used when a product has a cost price. Must be valid, pre-existing MYOB account number. 5 characters, numeric. May have an optional non-numeric separator between the first digit and the last 4 digits.


Product Condition
New
Here you can select the condition of the product which will be included in the Google Base feed.


Show Product Condition?
Y
Here you specify if the product condition is displayed on the product page. (Y=yes N=no)


Event Date Required?
N
Should the customer have to choose a date before they are able to purchase this product? If you sell products where a date is important (such as a delivery date for flowers or an attendance date for a concert) then you should tick this option. You will then be able to specify date-related options below. (Y=yes N=no)


Event Date Name
Delivery Date
The text in this field is used to identify this date field in your store. If you sell flowers you might use 'Delivery Date'. If you sell concert tickets you might use 'Concert Date'.


Event Date Is Limited?
N
This field controls if you want to limit the available dates for selection when a customer is adding this product to their cart in your store. Note that the available dates are inclusive of the start and end dates. (Y=yes N=no)
Available options are : Date Range, Start Date, or End Date.

The Date Range enables you to limit the date range (both start and end date) from which the customer can choose a date.



Event Date Start Date
Mar 4, 2011
Populate this field if you want to limit the start date from which the customer can choose a date.


Event Date End Date
Apr 4, 2011
Populate this field if you want to limit the end date up until which the customer can choose a date.


Sort Order
0
This field will control where in the list this product will be displayed when viewed in search results and category pages. The lower the number, the closer to the top of the results list the product will be shown. Also known as descending order.


Product Tax Class
Default Tax Class
You can specify here which tax class you wish your product to use. Your tax classes can be found by going to Settings -> Tax > Tax Classes.


Product UPC/EAN

Here is where you can put in the UPC for a product. This is technically the same field as the GPS Global Trade Item Number, so please make sure that there is a value in only one of these fields for each product.


Stop Processing Rules
N
When applying rules via csv use this to stop processing all rules underneath said rule. (Y=yes, N=no)


Product URL
/apple-mighty-mouse/
This is the relative path to your product on your store. The full URL for the product is not displayed, only the part of the URL after your domain name.


Redirect Old URL?
Y
If you change the Product URL, you can choose whether or not to create a 301 Redirect for the old URL to the new one.


GPS Global Trade Item Number
123456789012
The Google Product Search Global Trade Item Number is the UPC/EAN for the product. This field is used specifically for Google Product Search, so if you are not uploading your products to GPS, you do not need to enter in a value for this field.


GPS Manufacturer Part Number
BW292-G
The Google Product Search Manufacturer Part Number is the Product Code or SKU for the product from the manufacturer. This field is used specifically for Google Product Search, so if you are not uploading your products to GPS, you do not need to enter in a value for this field.


GPS Gender
Female
The Google Product Search Gender is the intended gender for the product (usually apparel). This field is used specifically for Google Product Search, so if you are not uploading your products to GPS, you do not need to enter in a value for this field.


GPS Age Group
10-12 years
The Google Product Search Age Group is the intended age group for the product (usually apparel). This field is used specifically for Google Product Search, so if you are not uploading your products to GPS, you do not need to enter in a value for this field.


GPS Color
White
The Google Product Search Gender is the color of the product (usually apparel). This field is used specifically for Google Product Search, so if you are not uploading your products to GPS, you do not need to enter in a value for this field.


GPS Size
M
The Google Product Search Size is the size of the product (usually apparel). This field is used specifically for Google Product Search, so if you are not uploading your products to GPS, you do not need to enter in a value for this field.


GPS Material
Cotton
The Google Product Search Material is the material with which the product is made (usually apparel). This field is used specifically for Google Product Search, so if you are not uploading your products to GPS, you do not need to enter in a value for this field.


GPS Pattern
Plaid
The Google Product Search Pattern is the pattern of the product (usually apparel). This field is used specifically for Google Product Search, so if you are not uploading your products to GPS, you do not need to enter in a value for this field.


GPS Item Group ID
ItemGroup13
The Google Product Search Item Group ID is usually assigned by BigCommerce when you enable a product for Google Product Search. We recommend that you leave this blank if you are importing products for the first time, and then let the system create this value for you when you enable Google Product Search through the control panel. This field is used specifically for Google Product Search, so if you are not uploading your products to GPS, you do not need to enter in a value for this field.


GPS Category
Shop Mac/Accessories
The Google Product Search Category is the category to which you assigned the appropriate taxonomy for your own products. (Please read this article if you have questions.) This field is used specifically for Google Product Search, so if you are not uploading your products to GPS, you do not need to enter in a value for this field.


GPS Enabled
Y
The Google Product Search Enabled is whether this product is enabled for GPS (using a N or a Y). If you are trying to enable GPS for your products through the CSV, you must previously have mapped your categories to a GPS category in the control panel, as you must put a Y for this field and call out one of the categories to which the product is assigned for it to import correctly. This field is used specifically for Google Product Search, so if you are not uploading your products to GPS, you do not need to enter in a value for this field.




Import Preview
Photo of Drew N

Drew N, Community Manager

  • 258,538 Points 100k badge 2x thumb

Posted 5 years ago

  • 0
  • 4
Photo of Marcy0335

Marcy0335

  • 1,452 Points 1k badge 2x thumb
I've imported a csv file with all my products in it and was hoping to have the ability to add the "Custom Fields" information (for the product description tabs). However, I noticed there is no header for this information even after I manually added custom field information to a few of my products. Is there an alternate way to do this, or is this something that is not available? I am not looking forward to manually entering this information to over 600 products :(

But on a brighter note...I am absolutely LOVING this new platform! There is so much more functionality and it's thousand times easier to use. Thanks Homestead for getting rid of the old (ancient, fossilized, archaic) ProStores platform. Best move you guys could have ever made!
Photo of Drew N

Drew N, Community Manager

  • 258,538 Points 100k badge 2x thumb
Unfortunately, we can't update the custom fields by CSV at this time. I am sorry for that.

We believe this is a great move as well.

Drew
Photo of Marcy0335

Marcy0335

  • 1,452 Points 1k badge 2x thumb
Thanks Drew. Not a problem...I figured a way around it.

I changed the warranty language in the template panel "ProductTabs.html"
to: "lang.Warranty = 'Other Details';"

Then, in the panel "ProductWarranty.html" I changed the title to "Other Details"

This allows me to create a text based structure (with some allowed html) of the information I want to create. I can now go into my csv file and concatenate the base structure in a separate XML file and then just add in the required information for each product. Then I just drop it all in the column "warranty" and upload to the site. WooHoo! Happy day!

If anyone has any questions about how to do this I will be more than happy to guide you through it :) It's really very easy!

Below is a screenshot of what this looks like:

Photo of Judith3144

Judith3144

  • 134 Points 100 badge 2x thumb
This reply was created from a merged topic originally titled
Turn off inventory.


I don't use inventory since my products are made after they are ordered. I have over 1000 products and now every time someone orders, they are told they product is out of stock and they can't order it. Am I really going to have to turn of the inventory button on over 1000 products? This is dreadful.

This conversation is no longer open for comments or replies.