Import Products in Bulk (BETA)

Note*

GRADUAL RELEASE: This feature is currently being tested and will be gradually released to all accounts. To use the legacy Product Import feature read this guide. For more information, contact us

To start using your TradeGecko account first you need to have all your products in your inventory. There are two ways to create new products on TradeGecko;

  1. Create a new product individually
  2. Import new products in bulk

To import new products in bulk go to Inventory>> Import New Products.You will see the following screen;

Screen_Shot_2017-11-21_at_1.58.27_pm.png

Select if you want to upload an existing spreadsheet into TradeGecko or if you want to download a spreadsheet from TradeGecko to fill up and use that for the import.

 

If you sell products that have multiple variants, you will need to select the respective box or learn more about products and variant definitions before you proceed.

Screen_Shot_2017-11-21_at_1.58.46_pm.png

You can now select which attributes you would like to set up in this import. Certain fields are required as seen below;

Screen_Shot_2017-11-21_at_1.58.56_pm.png

 Column Name

             Description

               Input

Product Name (required)

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? This has to match the name of an existing relationship.

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.

This value is required if you are importing products with variants.

This column is required if you are importing products with variants.

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 (required)

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 (required)

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, it is the most important column 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.

Initial Stock Level

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.

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.

Country of Origin

The country of origin of the product.

US, GB, AU, etc. Only alpha 2 country codes are accepted. Has to be in capitals.

HS Code

Harmonized System code. This is an international nomenclature (at 6-digit level) developed by the World Customs Organisation for the classification of goods.

123456 - The minimum is 6 digits.

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.

Select “Download Template”. A spreadsheet will be generated with all the selected fields. Fill in the fields and select “Next upload your products”.

Upload the file.

 

If you encounter this error message “invalid byte sequence in UTF-8”, it is because the software you used to save the spreadsheet does not encode characters in UTF-8 (the dominant encoding for the web).

To resolve this, you can either change the encoding on your spreadsheet file, or import the spreadsheet to Google Sheets and download it as a CSV from there. It should now be in UTF-8.

Screen_Shot_2017-11-21_at_1.59.12_pm.png

If you are uploading your own spreadsheet you will need to match your spreadsheet’s column headings to the relevant product attributes on TradeGecko.Screen_Shot_2017-11-21_at_1.59.25_pm.png

All required fields must be matched to a column on your spreadsheet. Select “Continue”

View a detailed breakdown of your import and confirm that the information presented is right.

The 2 most important columns are your initial cost price and initial stock level. These are used to determine the Moving Average Cost (MAC) of your product. If these are left blank, we will default the MAC to 0. This means that the cost of goods sold will be wrong once you start making sales and your intelligence reports will not show the correct profits.

The import will take a while depending on the number of products being imported. Feel free to explore and set up other parts of your account in the meantime.

Screen_Shot_2017-11-21_at_1.59.35_pm.png

Your inventory is now up to date and ready to be used!

Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF
Have more questions? Submit a request
Was this article helpful?
0 out of 1 found this helpful

Comments

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