Zap to sync Inventory from QBO to Ecwid

Hi ​@Eyal Israel,

Welcome to the Community.

Your integration between QuickBooks Online (QBO) and Ecwid is encountering issues with SKU mapping and sales receipt errors. To resolve SKU handling, ensure your Zap dynamically pulls SKU data from Ecwid orders rather than relying on static values, and verify that placeholders accept dynamic data. The sales receipt error, indicating a mismatch between amount and unit price, can be addressed by checking field mappings to ensure unit price and quantity calculations are correct, verifying data formats, and reviewing product details in Ecwid. Running tests with different products, checking Zap History for error logs, and carefully reviewing your Zap setup can help troubleshoot both issues effectively.

Feel free to ask if you need further assistance or have specific questions about setting up these steps.

The dynamic mapping isnt working out. Is there something I am missing out?

Also, what is the best to map to line amount field mapping pls?

Hi ​@Eyal Israel,

Before we dig deeper into this, could you please send a screenshot of the “CONFIGURE” section of the Create Sales Receipt step? Please ensure that all of the fields are captured in the screenshot.

(view larger)

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks!

Hi ​@Eyal Israel,

Thank you for the screenshot!

Could you please try mapping the Items Price data to the “Line Item Unit Price” field? The “Line Amount” field and the “Line Item Unit Price” field should be equal based on the error that we’re encountering.

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

here

Hello

I’ve done that already and sent a screenshot.

Hi ​@Eyal Israel,

It looks like we’re encountering an error of “The transaction date is before the item's inventory start date”. Could you please go to the “Transaction Date” field and ensure that the date is correct?

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Yes, I’ve done that.

Hello

Hi ​@Eyal Israel,

I recommend reaching out to our Support Team so they can take a closer look — they have the necessary tools to review your Zap and its logs in more detail.

You can contact them directly here: https://zapier.com/app/get-help

I appreciate your patience and understanding.