cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

How to change cost of products in past sales that were imported from BigCommerce?

How can the cost of products be changed in past sales that were imported from BigCommerce?

 

I imported orders from BigCommerce into QuickBooks Online starting from January 1, 2020. When running a profit and loss report within QBO for the month of January I noticed the Cost of Goods Sold seemed to be quite a bit off.

I will give a little more detail in case it helps. Upon going through the profit and loss report for individual products   I noticed some items had no cost associated with them but in BigCommerce every product has the cost field populated. I noticed one thing in common with all the products that were showing the cost as $0. All these products were product options/variants. The parent SKU/product has a cost of $0 associated with it because it is not actually a product for sale. The child SKU's all have their cost field populated but those amounts did not transfer into QuickBooks. A few parent SKU's had a cost assigned to them and the child SKU's had the parent SKU cost assigned to them but that amount was incorrect for almost every one of the child SKU's.

 

Please forgive any incorrect usage of terms as I am new to QuickBooks Online and accounting in general. I have done everything in Excel with the csv exports from BigCommerce up until this point but that was time consuming.

2 Comments
Highlighted
QuickBooks Team

How to change cost of products in past sales that were imported from BigCommerce?

Let me give you some information why the product's cost is 0$, I_dislike_making_up_screen_names.

 

After you have imported the products from BigCommerce, some of the details was not included. You'll consider checking the Products and Services section to see if the Cost of your product is entered before you sold it because it will reflect in the COGS that its 0$.

 

Here's how to correct it:

 

  1. Go to the Sales tab and choose Products and Services.
  2. Click Edit on the Inventory item and click the Starting value.


     
  3. Enter the Initial quantity and the Initial cost.
  4. Verify then click Save and close.

 

After you've change the Starting value and the Quantity of your product, make sure that you've created a purchase transaction.

 

Also, I’d recommend contacting their Support Team if you're till having this issue after doing the steps above. By doing so, they’ll be able to help you verify the details of your inventory from BigCommerce to QuickBooks Online. Here’s how to reach out to them:

 

  1. Go to https://apps.intuit.com/.
  2. In the Search field, enter BigCommerce for QuickBooks Online.
  3. Under the App information section, you can get their up-to-date contact information.

Let me know if you have any QBO- related questions. I'm ready to back you up. Take care.

Highlighted
Level 14

How to change cost of products in past sales that were imported from BigCommerce?

@I_dislike_making_up_screen_names 

As additional option, explore this 3rd party connector tool

https://automate.io?ref=quickbooks

 

Hope it helps.

Need to get in touch?

Contact us