Upload the Inventory CSV first to create products, then the Products CSV to enrich with pricing, weight, and images. Order quantities by variant.
Edit retail, cost, and shipping. Margins update automatically.
| Product | Collection | SKU | HS Code | Retail ($) | Unit Cost ($) | Ship Est. ($) | Total Cost | Margin | Weight (oz) | Vendor |
|---|
Counts per location. Upload inventory CSVs on the Data Upload tab — location names populate automatically from the CSV.
Define global options first, then assign them per product.
Add options below — they become selectable buttons on each product's tech pack.
Assign products to vendors — only assigned vendors appear in product dropdowns.
| Date | Holiday |
|---|
| Date | Holiday | Note |
|---|
Upload a Products CSV for pricing and images, then one Inventory CSV per location for stock counts.
Enter any identifier that appears within a SKU to map it to a collection — it doesn't have to be a prefix. For example MHE matches MHE-0402-HWABHOO-SML; LOGOMAG would match any SKU containing that string. Longer/more specific identifiers take priority. These become your collection filter options throughout the guide.
Export from Shopify Admin → Products → Export. Maps Variant Price, Cost per item, and Variant Grams (converted to oz) to products by Variant SKU. Upload after the inventory CSVs. Products not already in the guide are ignored.
Columns mapped: Variant SKU → Variant Price · Cost per item · Variant Grams → oz
Add one slot per collection. Enter the collection name, then drop the Shopify inventory export for that collection. Location columns are detected automatically from the CSV — everything after the COO column is treated as a location. Cells with "not stocked" are excluded entirely from the guide. Re-uploading a slot replaces all its data. Deleting a slot removes all its products and inventory.
Upload a CSV with columns: Title, Option1 Value, SKU, then one column per location with par quantities. Par levels are matched to products by SKU and displayed as a deficit (in red) on the Inventory and Products tabs when stock falls below par.
Columns: Title · Option1 Value · SKU · [Location 1] · [Location 2] …
Select which collections to include.