To automate the synchronization of new items created in Business Central with Shopify on a daily basis, you can implement a custom solution using a combination of Business Central's native features and possibly some custom development. Here's a proposed solution: Custom Job Queue: Instead of relying on the default Shopify Connector's 'Add Item' report, create a custom job queue specifically for synchronizing new items to Shopify. This job queue should be programmed to run daily. Filtering by Creation Date: Within the custom job queue, implement logic to filter items based on their creation date. You mentioned that the 'created at' filter only uses today's date and repeats it for subsequent days. To address this limitation, you'll need to incorporate custom logic to dynamically filter items based on their creation date. Custom Logic for Dynamic Date Filtering: You can achieve dynamic date filtering by utilizing Business Central's APIs and custom development. Write code to retrieve items created on the current day programmatically. This involves querying the Business Central database for items created within the last 24 hours. Integration with Shopify API: Once you've retrieved the newly created items, integrate with the Shopify API to add these items to your Shopify store. You'll need to map the fields from Business Central to the corresponding fields in Shopify. Error Handling and Logging: Implement robust error handling mechanisms to handle any failures during the synchronization process. Additionally, ensure that detailed logs are generated for troubleshooting purposes. Testing and Monitoring: Thoroughly test the synchronization process in a development or staging environment before deploying it to production. Monitor the job queue regularly to ensure that it runs as expected and troubleshoot any issues promptly. By following these steps, you can automate the synchronization of new items from Business Central to Shopify on a daily basis, ensuring that your inventory remains up-to-date across both platforms.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Mansi Soni as our August 2025 Community…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohail Ahmed 2,899 Super User 2025 Season 2
Sumit Singh 2,444
Jeffrey Bulanadi 2,304
