Workflow: Sage 300cloud to the B2B Trade Store

Below is a brief overview of how Stock2Shop syncs product updates from Sage 300cloud to the B2B Trade Store, and automatically raises online orders into Sage 300cloud as invoices or sales orders.

There are two main elements to this Stock2Shop integration:

  • Product updates
  • Order automation

Product updates

Stock2Shop can sync vital product data from your Sage 300cloud to the B2B Trade Store. This means that your wholesale customers and sales reps will see accurate stock levels and pricing.

We can, in fact, sync any of the data in your Sage 300cloud product table to your Stock2Shop console. You can then choose to add enrichment such as images and other marketing information before sending it to the following fields on the Trade Store:

  • SKU
  • Barcode
  • Title
  • Description
  • Images
  • Weight
  • Stock level
  • Product relationships (simple and configurable)
  • Categorisation
  • Multiple price lists
  • Contract (or Matrix) pricing
  • Any additional product attribute information

Below is a breakdown if the workflow for setting up this integration:


Stock2Shop can send your Sage 300cloud items to the B2B Trade Store where they are created as either simple or multi-variant products, depending on your data.

Preparing your data: You would need to mark which Sage items must sync to Stock2Shop, using the ALLOWONWEB tick box field.

You would need to add some Custom Fields to accommodate multi-variant products, as indicated on the example spreadsheet below:

  • Product Code. This is the parent code that groups SKUs together as variants of a single product.
    • It can never be blank.
    • If a product is simple (ie contains only one variant), copy the SKU into this field and leave the Product Option field blank. (see “Product D” as an example)
  • Product Option. This is the difference between any two variants as displayed to the customer on the website front end.

Using this workflow, you will be able to sync products from Sage 300cloud to the Trade Store where they will be configured as multi-variant products where required. For more information on the relationship between products and variants, click here.

SKU (Item Code) Description (title) ALLOWONWEB Product Code Option Stock Price
WAL-001 Wallet False A   30 80
GGLOVE-LH Golf glove - Left handed True B Left 40 40
GGLOVE-RH Golf glove - right handed False B Right 50 40
HOOD-S Hoodie - Small True C Small 50 60
HOOD-M Hoodie - Medium False C Medium 50 60
HOOD-L Hoodie - Large False C Large 50 70
HAT-CORP Corporate hat True D   50 80
WAT-001 Watch False E   50 1000
ACME-TS-S T Shirt - Small False J Small 50 20
ACME-TS-M T Shirt - Medium False J Medium 50 25

Order automation

In addition to syncing updates from Sage 300cloud to the Trade Store, Stock2Shop also automates the raising of orders back to Sage 300cloud as either invoices or sales orders.

Order automation is especially important if you are selling on multiple platforms channels, because it means that Sage 300cloud 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.

Why integrate Sage 300cloud for ecommerce?

Sage 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 Sage 300cloud, you will

  • Reduce duplicate data capture
  • Reduce human error
  • Eliminate the risk of overselling
  • Free up time for you to spend on growing your business

Contact us to find out how you can streamline your online business with a more efficient workflow.

Be first to know

Be first to know

Keep up to date with ecommerce news, trends and articles. Brought to you by Stock2Shop.

Sign up today

Related Articles


Read More
5 July 2018

Product Data: What You Need to Know

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
18 July 2018

How to Categorise Products: Layered Navigation

Categorising products correctly is a major pain point for many ecommerce websites. Layered navigation is the solution: find out how – and why – to implement it

Read More

Contact Us

Want to find out exactly how Stock2Shop can make your business more efficient and streamlined?

Contact Us