IntroductionThis article is to guide you on troubleshooting the error 'Transactions with inventory (QOH) products can't be dated earlier than the Inventory Start Date for the product'.
This means that within that shift that cannot be synced, the start date of a product(s) in StoreHub is earlier than its start date in QBO. To rectify this problem, you will need to trace the item(s) causing this issue, and change its Inventory Start Date in QBO.
How to Troubleshoot
Here are the steps:
First we need to identity the product(s) that is causing the error, and remove them from QBO.
Go to QBO > Settings > Products and Services > Run Report.
Customise > Created Date: Select Custom > Set From to be the next day of the day of the problematic shift > Run Report. The report generated is a list of products that have been created on or after the selected date.
Note down all the items on the report, and delete all of them on QBO.
Now we need to add the deleted item(s) back into QBO.
Go to StoreHub > Settings > Add-Ons > Check 'Refresh Products Mapping on Save' > Click Save and Resume.
Click 'Export Unmatched Products'.
Go to QBO > Settings > Import Data > Products and Services.
Click Choose File and select the unmatched products file that you have just downloaded from StoreHub > Continue.
A page will then load with all the product and services. Click Continue until you reach the Review Data tab. Please change the Quantity as-of-date to before the day you created the items in StoreHub. Click Import and you should be done.
Go back to your shift report in StoreHub and click 'Sync' for all the shifts that are not synced.
In future, when importing products into QBO, double check the 'Quantity as-of Date', and make sure that the date selected is before the date that you entered the item into StoreHub.