Products and variants
The Products, product and variant pages, how cost price and average cost work, how to exclude a product from forecasting, and how to import costs, thresholds, reorder points, bin locations and custom fields.
Products and their variants come from Shopify. StockWay reads their titles, SKUs, barcodes, prices, costs, vendors, tags and status, and keeps its own details alongside: an average cost, minimum order quantities, stock thresholds, reorder points, bin locations and custom fields. You create and edit products in Shopify.
The Products page
Open Inventory > Products, or type in the Search products box in the top bar. The list shows Product, Vendor, Status, Variants, Available and Stock value.
- Available is the total that can be sold across your active locations. Variants Shopify does not track, and bundles, add nothing; a negative level counts as zero.
- Stock value is that quantity at each variant's cost price. Variants with no cost price add nothing.
- Search title, vendor, SKU, or barcode finds products, and the status list filters by Active, Draft or Archived. Click Product or Vendor to sort.
- Add product opens Shopify's new product page in a new tab. A new product appears in StockWay shortly after you save it in Shopify.
The product page
Click a product to open it. Create variant opens the product in your Shopify admin, where variants are made. The page shows:
- a chart of units sold per week (cancelled orders and gift cards are not counted);
- Product details: image, vendor, product type, tags and publish date;
- Variants: Title, SKU, Barcode, Retail Price, Available, Incoming, Cost Price and Average Cost. Available shows a dash for a variant Shopify does not track, and for a bundle, whose stock belongs to its components.
Cost Price lists the Default Cost Price (the cost per item in Shopify) and the price each linked supplier has agreed; Local names a supplier's currency when it differs from yours.
The sales chart shows the last eight whole weeks, and its title reads Sales over last 56 days. Until Shopify approves StockWay to read your full order history, the chart stays at eight weeks, even when StockWay holds older orders.
The variant page
Click a variant title on the product page or on Inventory levels; product names on the Low stock report, adjustments, transfers and stocktakes lead there too. Open in Shopify ↗ opens the variant in your Shopify admin. Besides the sales chart, the page shows:
- Received purchase orders: the last 20 receipts, with date and quantity.
- Variant details: image, SKU, barcode, Retail Price, Compare Price, Average Unit Cost, Available, Incoming, Next Delivery Due and Weight.
- Suppliers: each linked supplier and its cost price.
- Locations: Available and Bin Location at each location; inactive locations are greyed.
- Incoming purchase orders: open orders with their expected date and outstanding quantity, earliest first.
On product and variant pages, Incoming counts units still to arrive on purchase orders that are ordered or partly received and not archived. It can differ from the Incoming column on Inventory levels, which is Shopify's own figure.
Costs
Cost price is Shopify's cost per item, and it is what StockWay values stock at. Change it in Shopify, or in StockWay:
- On Reports > SKU/Variants, click a Cost Price cell, type the cost and press Enter or click away. Leave it empty to clear the cost. The change is saved to Shopify first; if Shopify refuses it, the reason appears under the cell.
- With the Cost Prices import (below).
- When you receive a purchase order, if both Update supplier catalog cost when receiving and Push received cost to Shopify are ticked in the Purchasing card of Preferences.
Average cost is StockWay's own figure. Each time you receive a purchase order it is recalculated as a weighted average of the stock you held and the new delivery, with the order's shipping and other charges spread across its lines. Until a variant has one, its Average Unit Cost on the variant page shows the Shopify cost. To bring average costs across from another system, use the Initial Average Costs import.
Exclude a product from forecasting
An excluded product is kept out of forecasting and replenishment: the low stock reports, the purchase planner and the dashboard. There are three ways to exclude one:
- Archive it in Shopify. Archived products are always excluded. Draft products are not.
- Use the row menu. On Reports > SKU/Variants, or Reports > Low Stock > SKU/Variants, open the ▾ menu at the end of a row and choose Exclude from forecasting. It applies to the whole product, which then drops off the low stock report; it stays on the SKU/Variants report, where Include in forecasting undoes it.
- Tag it. In Preferences, the Inventory card's Ignore products tagged box takes a comma-separated list of tags. Products carrying any of them are excluded; capital letters do not matter.
stocky:ignoreis in the list unless you remove it.
Import product data
Click Import on the Products page and choose what to import. Each type reads its value from one column:
| Import | Value column |
|---|---|
| Cost Prices | cost |
| Initial Average Costs | average_cost |
| Minimum Orders | minimum_order |
| Minimum Stock, Maximum Stock | minimum_stock, maximum_stock |
| Reorder Points | reorder_point |
| Bin/shelf Locations | bin |
| Text 1, Text 2, Text 3, Custom date | text_1, text_2, text_3, date |
Minimum Stock, Maximum Stock, Reorder Points and Bin/shelf Locations are set per location; the rest per variant. Custom fields show the names you gave them in Preferences, Custom fields. Cost Prices are saved to Shopify first. Initial Average Costs keeps values already set unless you tick Replace average costs that are already set. Minimum Orders sets the smallest quantity the purchase planner suggests for that variant.
- Choose the type, then click Download template for an example file.
- Name each variant in a
sku,barcodeorvariant_idcolumn, add alocationcolumn with the location's name for per-location types, and put the value in the value column. Column order and capital letters do not matter, and a space in a heading counts as an underscore, soMinimum Stockalso works. An empty value clears what is stored, except for Initial Average Costs. - Choose the CSV file, or paste it under …or paste the CSV instead, and click Check file.
- Check Will change, Already match and Problems, the Changes table and any Rows that cannot be imported.
- Click the Import button, which shows the number of changes. If any row has a problem, nothing is imported unless you tick Import the valid rows only…
- A file can hold 20,000 rows. Quantities are whole numbers of 0 or more. Costs may include a currency symbol and are kept to six decimal places. Write decimals with a point, as in
12.50: commas are ignored, so12,50would read as 1250. Dates are writtenYYYY-MM-DD; text can be 255 characters long. - Each variant, or variant and location, can appear once. If a SKU belongs to more than one variant, use
variant_id. You can leave out the location column only if your store has one active location.
Still have a question? Email us and we will help you get set up.
ilyasstaibi1992@gmail.com