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.

Position

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.