Stock adjustments
Create a stock adjustment at one location, add products by search, scan, bulk add or CSV, choose a reason, perform it in Shopify, and print or download it.
A stock adjustment corrects the quantity of one or more products at a single location: damaged stock, losses, theft, stock found or returned, or a count correction. You build it as a draft, line by line, choose a reason, then perform it. StockWay writes all the lines to Shopify in one go and keeps the adjustment as a record you can print or download. To move stock between two of your locations, use a transfer instead.
Create an adjustment
- Open Inventory > Adjustments.
- Click Create adjustment.
- In New adjustment, choose the Location and click Create.
The draft opens, headed Stock adjustment and its number. Only active locations can be chosen; until one has synced, the button is unavailable.
Add products
The first row of the table is the entry row.
- In the product box, type a SKU, barcode or product name and choose from the list, or scan a barcode.
- Choose adjust by to change the quantity (for example
-3), or set to to give the new quantity. - Enter the quantity and click Add.
- An adjust by change cannot be 0, and a set to quantity cannot be negative.
- After scanning or typing a code into the box, the scan button (▥) adds the product with a change of +1, or adds 1 more if it is already on the adjustment. If the quantity box holds a number other than 0, it adds that number instead. The box is cleared and ready for the next code. A set to line cannot be scanned again; change or remove it first.
- To change a line, enter the product's exact SKU or barcode again with the new figures and click Add: the new entry replaces the line. The suggestion list leaves out products already on the adjustment. To remove a line, click ✕ at its end.
- Only products whose inventory Shopify tracks can be adjusted.
Add many products at once
Open the Add products menu:
- Bulk Add Variants adds every tracked variant from a vendor, from a supplier, matching a search, or already stocked at the location, or just the ones you tick after a search. They arrive as lines with a change of 0 for you to fill in, and lines already on the adjustment are left alone. A line left at 0 changes nothing. If your choice covers more than 250 variants, nothing is added and you are asked to narrow it.
- Import CSV reads a file with a
skuorbarcodecolumn and either anadjustmentcolumn (a change, such as-3) or anew_quantitycolumn (the new quantity). It takes up to 250 rows, and products already on the adjustment are left as they are. If any row has a problem, such as a code that matches nothing or a change of 0, nothing is added and the message lists the rows at fault.
The from a supplier choice covers only products added to that supplier individually, not the products it supplies through its vendors. For a supplier set to By Shopify Vendor, choose from a vendor instead.
Choose a reason
Below the table, fill in Reason, Notes and Employee. There is no Save button: each field is saved as you leave or change it. You must choose a reason before you can perform the adjustment. StockWay sends each reason to Shopify as one of Shopify's own adjustment reasons:
| Reason in StockWay | Reason sent to Shopify |
|---|---|
| Damaged | Damaged |
| Lost | Shrinkage |
| Theft | Shrinkage |
| Found / returned to stock | Restock |
| Count correction | Correction |
| Promotion / giveaway | Promotion |
| Quality control | Quality control |
| Other | Other |
Perform the adjustment
- Check each line: Available quantity (the stock when the line was added), Adjustment and New available quantity.
- Click Perform Adjustment.
StockWay sets the new Available quantity in Shopify for every line and tells you how many lines Shopify applied. Lines that already held the requested quantity are left as they are. The adjustment is marked applied, moves to the Archived tab and can no longer be changed, and a notification appears under the bell.
Two safety checks can stop it:
- A line would go below zero. The message names the product. If that is what you intend, tick allow negative stock, which then appears under Employee, and perform again.
- Stock moved in Shopify since the line was added, for example through a sale. Nothing is applied. Click Refresh stock to re-read Available for every line, check the figures and perform again; an adjust by line then applies to the new figure. Or tick apply anyway, even though stock moved to overwrite Shopify with your numbers.
To abandon a draft, click Cancel adjustment. It moves to Archived as cancelled, and nothing changes in Shopify.
Columns, print and download
- Columns switches SKU, Barcode, Status (the product's status in Shopify), Available quantity, Adjustment and New available quantity on or off while you view the page. Barcode starts off, and the choice is not saved. Product and Variant are always shown.
- Download > PDF opens a print-ready sheet in a new tab with your store details (and logo, if you have uploaded one), the status, reason, employee, date performed, lines and notes. The print dialog opens by itself: choose a printer, or save as PDF. Print / Save as PDF opens it again.
- Download > CSV downloads the lines with Product, Variant, SKU, Available quantity, Adjustment and New available quantity. Once performed, New available quantity is the figure Shopify confirmed, and is blank for lines Shopify did not change.
Find adjustments
The Open tab lists drafts, oldest first. Archived lists performed and cancelled adjustments; a cancelled one is marked cancelled next to its reason. Each row shows No. with the location beneath, Reason, Notes, Adjusted by, Adjusted at and Variants. Search by number, note or employee. Applying a stocktake that changes stock also creates a performed adjustment here, with the reason Count correction. For every adjustment line in one list, open Reports > Adjustments.
Still have a question? Email us and we will help you get set up.
ilyasstaibi1992@gmail.com