If you want to readjust your Moving Average Cost, please get in touch with us.
Whilst we recommend creating variants within your QuickBooks Commerce account and publishing them out to connected sales channels, there are times where you may need to create variants directly within a sales channel and have them sync over to QuickBooks Commerce.
When doing so, QuickBooks Commerce will import the variant, including the available attributes from the associated channel. However, if the sales channel does not support the use of a cost price (the cost to you for acquiring existing stock), QuickBooks Commerce cannot create an Initial Cost Price, causing each of the imported variants to have a Moving Average Cost of 0.
To ensure you're able to track costs and profits accurately for imported variants, you'll need to perform an import of your variant's Initial Cost Price.
Follow our simple guide-through below:
Once your variants have synced to QuickBooks Commerce, from the main navigation bar, click on Inventory > Products, then click the Bulk Manage button and select Import Initial Costs from the dropdown.
Next, you should see this screen:
Select the Download a list of your variants option to download a CSV file containing each of the variants you can set an Initial Cost Price for.
Within the .CSV file, add your variant costs (per unit) to the Price column and save the file.
Next, drag your newly saved file into the shaded box (you can also click to select your file), then click the green UPLOAD button. Your cost prices will now be imported into QuickBooks Commerce.
*The above example is only for demonstration purposes. The initial costs prices have already been imported; hence, you see 0 variants.
Click the 'Yes, this is correct' button on the review screen. Then, you will be redirected to your Inventory.
Your variants' updated cost values will now be displayed on the right-hand side of the variant details page. 🎉
