Own webstore · Weekly
Store prices vs. ERP prices
Check each SKU's webstore price against your ERP's price, and catch special prices left running past their end date.
Files you need
- Webstore prices: Your store's catalogue: price per SKU, with any special (sale) price and its dates.For example: Magento 2 product prices with special prices, Shopify products export, WooCommerce products export.
- ERP item prices: The selling price your ERP holds per item, on the same VAT basis as the store.For example: Business Central items (unit price), Odoo product sales price, Zoho Inventory items.
The Magento 2 / Adobe Commerce connector can fill: Webstore prices. The Microsoft Dynamics 365 Business Central connector can fill: ERP item prices.
What Sawwi checks
- Price differs from the ERP: The store's regular price isn't the ERP's price, so orders are invoiced at a different price than the shopper paid.
- Special price past its end date: A special price whose end date has passed is still set. Magento stops applying it, but it's stale: remove it or extend it on purpose.
- Special price above the regular price: The sale price is higher than the regular price, usually a typo.
- Priced online, unknown to the ERP: A SKU the store sells that has no item in the ERP.
What you get
- Price differences to correct
- Stale special prices
- SKUs missing from the ERP
- Excel download of every table
Used for
Bring last month's exports and see what's missing.
Setup takes two minutes. Or try the demo store with invented data first, no sign-up.
Create your workspace