Add Columns to the Update Existing Products template

There are five columns you can add to the "Update Existing Products" template. They are

  1. Position
  2. Keep Selling
  3. Max Online
  4. Minimum Order Quantity
  5. Batch Tracked

You can add the column to any part of the template.


Add this column to determine how your variants are positioned on your B2B eCommerce platform. For example, to position your variants as S, M & L; create a column named position (all in lowercase) and number the variants as follow:

  • S would be 1
  • M would be 2
  • L would be 3

It is best to create this column next to the variant column to avoid mixing up the numbered values.

Keep Selling

Add this column if you need to enable the keep selling past 0 functionality for your products. Create a Column named keep_selling and indicate either TRUE or FALSE for each variant.

Max Online

Add this column if you want your store to show a maximum amount of stock regardless of the quantity you hold in your inventory. For example, if you hold  200 of product X in your inventory, you can use the max online function to only show 50 items in stock.

To enable this, create a column named max_ online and indicate numerically (eg: 5, 8, 10) the maximum quantity you wish to display for each variant.

Minimum Order Quantity

Adding this column lets you update the minimum order quantity for your B2B eCommerce platform in bulk. Create a column called minimum_order_quantity and indicate numerically (eg: 20, 25, 34) the minimum order quantity you wish to apply to each variant.

To learn how to edit your spreadsheet, click here for more details. 

Batch Tracked 

Adding this column allows you to enable batch tracking for products in bulk. Create a column called Batch Tracked and input the value TRUE or FALSE for each product. For more details, click here. 

There is a handy guide to find out more on each column description, click here.

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?
0 out of 0 found this helpful