Product fields in Sumtracker explained in detail

Editable fields which are used to create or update product

Name

Name should be descriptive and unique. Sumtracker fetches the name of the product from the online listing. For products you create in Sumtracker the name can be anything which helps you identify the product.

SKU

Also called stock keeping unit, should be unique. SKU is very important field in Sumtracker. When you connect your online store Sumtracker will automatically fetch all the listings / variants from your store and save them in Sumtracker. Listings which have duplicate SKU will linked to the same product in Sumtracker for common inventory.

Variant Name

Variant name describes which variant is this product for. For example you can have 3 variants for a t-shirt with sizes M, L and S. The variant name for the S size will be "S".

UOM

Also called unit of measure. Can be values like kg, m, pcs. The stock quantity is in this UOM. For most products the UOM is assumed to be pcs unless you set it to a different value. 

Category

To categorise products. You add any category name you like. You can use the category field to filter out data in Sumtracker. For example if you want to see sales only for "Chairs".

Barcode

You can add a barcode if you want to search products using barcodes. Barcodes are printed on the product packaging by the manufacturer.

Alert Threshold 

When inventory of the product reaches this quantity, it will be included in the low stock report. For example if you set the alert threshold as 10 and the stock is 9, then you will receive a low stock alert email from Sumtracker for the product. If the stock reaches above 10 the low stock alert will not include that product in the report.

Close at Quantity 

When inventory of product reaches this quantity, it will be marked as sold out on all stores. For example you have the close at quantity as 2 for a product called black pants. When the stock for black pants reaches 2 Sumtracker will update the stock for black pants as 0 on the online store. This is done to prevent over selling a product if the product has many duplicate listings or is added to many bundles.

Cost per Item/unit

Cost per unit is included in certain reports like Stock valuation and cost of goods sold.

Tax

This is the product's default tax rate that will be picked while creating purchase orders.

Notes

Any notes you want to include about the product.

Inventory Sync

Can turn on or off. If the inventory sync is turned off for a product, its inventory will  not be updated on your online store by Sumtracker.

Image

The image is fetched from your online listings. You can also upload the image using upload image button on the edit product page.

Non Editable (read only) fields included in the bulk excel export

Sumtracker supports bulk excel export of all the products. Some of the columns in the excel are read only. Which means when you do editing in the excel data changes in the below columns will be ignored.

id

Id is the unique identifier of the product which Sumtracker assigns to the product.  This cannot be edited. 

For all existing products which were exported in the excel data, the value of the id field will be present and must remain as is. 

For any new products you want to create you have to leave the id column blank.

In Stock

This the physical stock you have in your warehouse. If you have multiple locations this is the sum of "in stock" quantity value of all warehouses.

Booked

This is the unfulfilled quantity which the quantity you have in your Open orders. If you have multiple locations this is the sum of "booked" quantity value of all warehouses.

Available

This is the available to sell quantity. Available qty = In Stock - Booked. If you have multiple locations this is the sum of "Available" quantity value of all warehouses.

Incoming

This is the quantity which is due in purchase orders. For example if you have created a PO for 10 quantity and 4 have been received. The incoming quantity will be 6. If you have multiple warehouses this is the sum of "Incoming" quantity value of all warehouses.

Bundle type

A product can be a normal selling product or a bundle. The value of bundle type will be NONE for a normal selling product and "BUNDLE" for a bundle product.

Is archived

If you are not selling a product anymore or if the product is not needed, you can mark the product as archived. The value for this field will be "True" if the product is marked as archived. Check this guide on how to archive products. 

Total cost

This is the total value of the product which calculated by multiplying the in stock quantity by cost.