What to do when every price is custom?

Involute13 · ‎November 13, 2023

I'd like to use Quickbooks Online (QO) for a business I'm starting and haven't been able to find an answer to one particular question. I'd be using it in conjunction with a Shopify store, so Shopify would automatically send the orders to QO. From what I've been able to tell so far, QO wants to assign a specific price to a specific product. In my case, though, let's say I'm selling boxes, but every box is custom. The price is determined solely by the x, y, and z dimensions. So, Shopify will collect a part number (which will be the same for all boxes), the dimensions, and the calculated price, and send all that to QO. Will this cause a problem for QO, since the same part number will always (well, usually), come with a different price associated with it? If this can be accommodated, how?

CharleneMaeF · ‎November 13, 2023

Hi there, Involute13. I appreciate you for choosing QuickBooks Online to manage your sales and expense transactions.

QuickBooks Connector can only assign the COGS account for the products upon creation but won't sync the COGS price of products.

When you integrate Shopify into QuickBooks Online, sales are only imported as summarized sales receipts, refund receipts, and fees. After you connect, it won’t affect your products and inventory in both QuickBooks and the program.

Since this is a third-party application, I recommend visiting the Shopify Community for more info about this.

I'm only a few clicks away if you need assistance managing your items in QuickBooks. It's always my pleasure to help you out again.

View solution in original post

CharleneMaeF · ‎November 13, 2023

Hi there, Involute13. I appreciate you for choosing QuickBooks Online to manage your sales and expense transactions.

QuickBooks Connector can only assign the COGS account for the products upon creation but won't sync the COGS price of products.

When you integrate Shopify into QuickBooks Online, sales are only imported as summarized sales receipts, refund receipts, and fees. After you connect, it won’t affect your products and inventory in both QuickBooks and the program.

Since this is a third-party application, I recommend visiting the Shopify Community for more info about this.

I'm only a few clicks away if you need assistance managing your items in QuickBooks. It's always my pleasure to help you out again.

Involute13 · ‎November 13, 2023

Thanks so much for the prompt and detailed reply.

”but won't sync the COGS price of products”

So, I’ll have to manually enter the price for each sale?

Angelyn_T · ‎November 13, 2023

Let me clarify things for you today, Involute13.

Yes. You can manually enter the price for each sale to ensure accurate tracking of your costs and profits. The good news is that you may always look for a third-party application to ease the process.

Also, I'm adding this material to learn more about integrating Shopify sales into our system: Shopify for QuickBooks Online.

On the other hand, you may check out the resources from this material for more hints on handling inventory data in QuickBooks: Set up and track your inventory in QuickBooks Online.

If you have follow-up questions while managing the prices of your items, let me know by leaving a comment below. I'm just a few clicks away to help you once more. Keep safe!

Topics

Training

Community

Resources

What to do when every price is custom?