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.