Marketplace Sales Conversion Tool (Shopify, Walmart)
The Marketplace Sales Conversion Tool was created to allow SoStocked users to take off-Amazon sales reports and convert them into a Demand Plan, which can be uploaded to SoStocked to create custom off-Amazon forecasts for platforms such as Shopify, Walmart, Etsy, etc.
SoStocked does not have API connections or integrations to any other platform than Amazon. So this is a workaround to create forecasts for these off-Amazon sales channels.
The Demand Plan allows you build a custom forecast for 52 weeks of sales, including seasonality, future sales spikes and holiday deals in one bulk upload. Make sure you have watched the tutorial on the Demand Plan before using this conversion tool.
The video below will walk you through the entire process:
Summary
- Create a custom regional grouping to simulate your off-Amazon marketplace and forecast.
- CONDITIONAL: If you do not have an inactive Amazon marketplace to use for step 1, then you will need to create new duplicate product listings in SoStocked.
- Download the Demand Plan bulk export.
- Go to the Marketplace Sales Conversion Tool and fill out the required fields.
- Upload the Demand Plan into the Marketplace Sales Conversion Tool.
- CONDITIONAL: If your product key identifiers do not match those listed in Amazon, you will need to upload a matching file.
- Export your sales report from the off-Amazon marketplace, such as Shopify.
- Match the required columns from your export to the tool.
- Export the new Demand Plan from the tool. This Demand Plan now contains 52 weeks of forecasted sales per SKU.
- Upload your Demand Plan into the Bulk Import page of SoStocked.
- Edit your Transfer Schedule to 2 days only for these off-Amazon forecasts. Since the forecast was designed for Amazon FBA, this is merely a workaround to simulate sales on "Amazon" which are really happening on your other sales channel.
If you have any trouble, please reach out to us at [email protected] or submit a support ticket through your Carbon6 login main menu.
How to Simulate Sales and Set up Your Forecast
Now that you have your off-Amazon marketplace and forecast uploaded, you will need to set up your forecast so that the sales are realistic and the lead times are correct, based on your workflow. NOTE: This video below was originally filmed for our workaround before the Demand Plan Marketplace Conversion tool so there are some references to an old workflow, but the concepts are the same.
If you have not studied the tutorials on setting up your Forecasts, or if you need a refresher, please do so here.