Import Products via CSV

 

To import products via csv, go to the Inventory section of your main app manager and click on ‘Import New Products’.

Screen_Shot_2017-03-10_at_5.03.57_PM.png

There are two templates available for you to import your product information via .csv - the basic product import and full product import template. The difference between the two templates is the number of product details you can input.

Basic product import template: product name, option 1 label, option 1 value, option 2 label, option 2 value, option 3 label, option 3 value, variant name, variant SKU, wholesale price, retail price, buy price, initial cost price, stock.

Full product import template: product name, product type, product description, supplier, supplier code, brand, tags, option 1 label, option 1 value, option 2 label, option 2 value, option 3 label, option 3 value, variant name, variant description, variant SKU, weight, wholesale price, retail price, buy price, initial cost price, stock, taxable, manage stock, keep selling, publish online, B2B eCommerce.

Should I use the basic product import template or the full product import template?

If you are just starting to use TradeGecko it is advisable that you use the basic product import template, with the essential product characteristics to run your business. To add more product details, use the full product import template.

Note
Using the basic product import template to import new products will accelerate your initial setup but it is important to update the other fields when you have the relevant information ready. You can do so by following the instructions here.

Now that you know the difference between using the basic template and advanced template, Click to download your preferred template.

Fill up the spreadsheet (more details on filling up each column at the end of this article ) and re-upload it. Please make sure that you have added the Initial Cost Price for each variant as you will NOT be able to edit it later on. If you do not know what Initial Cost Price is, click here

If you wish to update multiple price lists during your import, you can do so by editing the relevant columns in the spreadsheet. To learn more about updating multiple price lists via csv, click here to find out

 


If your upload is successful, you will see the following: 


Confirm the number of product variants you have uploaded.

Success! Your products have been imported.

If your spreadsheet contains errors on all products, you will prompted to download the error spreadsheet, like this:

 

Download the spreadsheet with errors, fix the indicated errors and re-upload the spreadsheet. The error spreadsheet looks something like this:

Fix the errors and re-upload your spreadsheet

Awesome!

If your uploaded spreadsheet contains some errors, you will see this:

At this point, click ‘Import products now’ to upload the product variants without errors. Click ‘go back’ to fix the errors that you are aware of and then re-upload your spreadsheet.

Great! Now the product variants without errors have been imported successfully. Fix the remaining errors by clicking on ‘Now let’s fix some errors’.

Download the spreadsheet with errors and proceed to upload the error spreadsheet to complete your product import.

Everything looks good now. You can now view your products in your inventory. If it is not there yet, refresh the page and it should appear now. 

Explanation of Columns in spreadsheet

Below is a list of the column headers you will see in your templates and what each column requires from you, as well as the format you should use to input the information. Please follow the instructions to reduce errors while importing.

  Column Name

              Description

                Input

Product Name

Name of the product.

Eg: Almost famous tee.

Product Type

What kind of product is this.

Eg:T-shirt, mug etc.

Product Description

What makes it special.

Eg: Athletes have won more championships and medals with the Sneaky A Frame more than with any other single sport product on earth.

Supplier

Who is your wholesaler?

Eg:Ts4You Clothing Wholesaler.

Supplier Code

Alpha-numeric code you attribute to this Supplier.

Ts4You-01

Brand

Brand of the product if applicable

Eg: Nike, Grohe

Tags

Tags you wish to associate with this product

Eg: Sports, Cutlery, Gift

Option 1 Label

Label - Refers to the categories you can distinguish the products by.


Value - Refers to the different option within the category you mentioned in the Label column.


Note
You may fill in up to 3 options but NOT more than that.

For label, input info such as Size, Colour, Material etc.

For example, an option label ‘Size’, will see option values such as Small, Medium, Large. In another example, the option label ‘Color’ will see option values such as yellow, blue, red.

Option 1 Value

Option 2 Label

Option 2 Value

Option 3 Label

Option 3 Value

Variant Name

Insert Variant Name

Eg: Blue Linen Shirt (M)

Variant Description

Short description of the variant

Eg: Same idea as product description, fill in if needed.

Variant SKU

Each SKU must be unique or an error will be generated

Eg: DCP021-XL

Barcode

Insert Barcode number if applicable.

Optional field.

Weight

Insert weight if you distinguish your products by weight.

Eg:100g

Wholesale Price

This is determined by your base currency and price list.

Insert the price without the $ sign.

Retail Price

This is determined by your base currency and price list.

Insert the price without the $ sign.

Buy Price

This is determined by your base currency and price list.

Insert the price without the $ sign.

Initial Cost Price (ICP) per unit

ICP and stock go hand in hand, most important in whole spreadsheet. ICP is based on the stock you currently have.What you put here as your ICP is what your MAC will be at this point.

Note
ICP cannot be changed after this point.

Insert the price without the $ sign.

Stock

Your ICP is dependant on whether you have stock. This means that if you have stock, you will have an ICP. If you don’t, you can leave it blank along with the ICP column.

Put in the numerical value of stock. For example if you have ten shirts, insert 10 here.

Taxable

Whether this product is taxable or not

Indicate TRUE or FALSE.

Manage Stock

Activates the keep selling function. If you click TRUE it will allow you to keep selling past zero. If you click FALSE you will not be able to keep selling once your stock level has reached zero.

Indicate TRUE or FALSE.

Keep Selling

Allows items to be sold even if they're out of stock on your online channels

Indicate TRUE or FALSE.

Publish Online

Only works for Woocommerce.

Note
If you wish to publish products from your Shopify or Magento stores add column(s) and fill in the name of the store(s) in the header. Each store must have a separate column such as Shopify 1 and Shopify 2.

Fill in TRUE or FALSE accordingly.

Private B2B e-Commerce Portal

This is for our customers using our Private B2B e-Commerce Portal

Indicate TRUE or FALSE.

                    Optional Additional Columns- You can create these if required.

reorder_point

Your reorder point is the point at which your stock has reached a certain level and needs to be ordered. Once you have indicated this point you will be able to run a report via Intelligence. This report will then tell you which products require re-ordering.

Put in the numerical value of the reorder point.

Eg: 4 or 10.

max_online

The amount of stock that you wish to display as available on your ecommerce store.

Eg: You may have ten cups but only wish to display five as available, the number to insert here would be 5.

sellable

If the variant or product is sellable or not.

Indicate TRUE or FALSE.

position

Within this column, number your variants according to the order in which you would like to view them in your inventory.

Eg: If you have three sizes, S, M & L and you would like them to be displayed in that order, then S would have a corresponding value of 1, M would be 2 and L would be 3.

For more information on additional columns you can add, click here

 

Frequently Asked Questions

1. How many variant options can we add?
You can add 3 variant options.

2. Why can't I add my own custom price list/ Why doesn't my custom price list appear?
You can now edit your custom price lists via csv at the import products stage. To update multiple price lists, follow the instructions here

3. How do I import Composite Variants from the template?
We don't have support for this at the moment. You'll have to create composite variants manually.

4. Why is my barcode/EAN value not formatted properly after uploading?
When importing inventory CSV to TradeGecko, there's an Excel bug that treats barcode column as numbers so it strips any leading zeros (when the CSV is exported out)
Example 1: 000000000845 would be converted to 845
Example 2: Some versions of Excel export barcode such as 1000000000 as 1e14


There are also instances where the barcode numbers are embedded with comma delimiters. Moving forward, we are dealing with improper formatting that's added by Excel here.
Workaround: Before exporting the CSV from your Excel program, make sure that the barcode column data type is String.

Note
If you are located in the EU, you may face an error when you export csv from TradeGecko and open in Excel. This is because Excel in the EU searches for semicolons whereas in Singapore and other regions, Excel searches for commas. Pro tip: on Excel, format the commas to semicolons or vice versa depending on your needs.
Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF
Have more questions? Submit a request
Was this article helpful?
4 out of 9 found this helpful

Comments

NEW TO TRADEGECKO? START A 14 DAY FREE TRIAL, NO CREDIT CARD REQUIRED