Be first to know
Keep up to date with ecommerce news, trends and articles. Brought to you by Stock2Shop.Sign up today
Below is a brief overview of how Stock2Shop syncs product updates from SYSPRO to Shopify, and automatically raises online orders into SYSPRO as invoices or sales orders.
There are two main elements to this Stock2Shop integration:
Stock2Shop can sync vital product data from SYSPRO to your Shopify website. This means that your online customers will see accurate stock levels and pricing.
We can, in fact, sync any of the data in your ERP product table to the Stock2Shop console. When it comes to sending data to your website, we are limited by the Shopify API to the following fields:
We can accommodate two types of workflows for this integration:
Stock2Shop can sync updates to products that already exist on your ecommerce channel. This is useful if you already have a website that is populated with products. Stock2Shop will ensure that pricing and stock levels are kept up to date in near real time.
Preparing you data for Workflow 1:
|SKU (Stock Code)||Description (title)||Online Sync||Stock||Price|
|GGLOVE-LH||Golf glove - Left handed||Active||40||40|
|GGLOVE-RH||Golf glove - right handed||Ignore||50||40|
|HOOD-S||Hoodie - Small||Active||50||60|
|HOOD-M||Hoodie - Medium||Ignore||50||60|
|HOOD-L||Hoodie - Large||Ignore||50||70|
|ACME-TS-S||T Shirt - Small||Delete||50||20|
|ACME-TS-M||T Shirt - Medium||Ignore||50||25|
Stock2Shop can send your SYSPRO items to your ecommerce channel where they are created. This is useful if you are launching a new website and want to sync your SYSPRO data directly onto your website. Stock2Shop can accommodate simple and multi-variant products.
Preparing you data for Workflow 2: You would need to add some Custom Form Fields as indicated on the example spreadsheet below:
Using this workflow, you will be able to sync products from SYSPRO to your website where they will be configured as multi-variant products where required. For more information on the relationship between products and variants, click here.
|SKU (Stock Code)||Description (title)||Online Sync||Product Code Sync||Option||Stock||Price|
|GGLOVE-LH||Golf glove - Left handed||Active||GGLOVE||Left||40||40|
|GGLOVE-RH||Golf glove - right handed||Ignore||GGLOVE||Right||50||40|
|HOOD-S||Hoodie - Small||Active||HOOD||Small||50||60|
|HOOD-M||Hoodie - Medium||Ignore||HOOD||Medium||50||60|
|HOOD-L||Hoodie - Large||Ignore||HOOD||Large||50||70|
|ACME-TS-S||T Shirt - Small||Delete||ACME-TS||Small||50||20|
|ACME-TS-M||T Shirt - Medium||Ignore||ACME-TS||Medium||50||25|
In addition to syncing updates from SYSPRO to Shopify, Stock2Shop also automates the raising of orders from your website back to SYSPRO as either invoices or sales orders.
Order automation is especially important if you are selling on multiple platforms channels, because it means that SYSPRO will know about an online purchase as soon as it is placed on one of your platforms. This in turn allows Stock2Shop to promptly alert your other platforms of the reduction in stock availability, virtually eradicating the chance of overselling.
SYSPRO already controls your company’s inventory and pricing. With Stock2Shop, you extend that control to all the places that you sell online. By centralising the management of your product data in SYSPRO, you will
Contact us to find out how you can streamline your online business with a more efficient workflow.
Understanding product data is essential for a successful ecommerce business. Here’s an overview of the most important elements of product data you need to understand.Read More
Categorising products correctly is a major pain point for many ecommerce websites. Layered navigation is the solution: find out how – and why – to implement itRead More
Want to find out exactly how Stock2Shop can make your business more efficient and streamlined?Contact Us
We would love to take you through a no-obligation demonstration of how Stock2Shop passes data between systems. Fill out the form below, and a salesperson will be in touch to arrange a conference call, or to simply contact us for more information.