Whilst we recommend creating variants within your QuickBooks Commerce account and publishing out to connected sales channels, there are times where you may need to create variants directly within a sales channel and have them sync 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 is not able to 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.
We'll guide you through this simple process below:
Once your variants have synced to QuickBooks Commerce, navigate to Inventory > Products, then click the Bulk Manage button and select Import Initial Costs.
You will see the following screen:
Select the Export your initial cost price CSV optionto download a CSV file containing each of the variants you can set an Initial Cost Price for.
Add your variant costs (per unit) to the Price columnand 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.
Click the DONE button to return to your Inventory.
The updated cost values for your variants can now be viewed on the right-hand side of the variant details page.
