RedMart's order feed doesn't include item selling prices, so RedMart orders can appear with $0 sales value in revenue reports. Here's why, what it does and doesn't affect, and how to get your sales values loaded and backfilled.
If you sell on RedMart, you may notice that your RedMart orders show up in OneCart with no sales value, or that your revenue figures count RedMart sales as $0. This is expected behaviour caused by a limitation in the data RedMart sends, not a sync error in OneCart. This article explains why it happens, what it affects, and how to get your RedMart sales values populated.
When RedMart sends order details to OneCart, the feed is built around fulfilment. It tells OneCart what to pick and how many units for each order so you can pack and ship correctly. What it does not include is the selling price for each item.
Because the price per item isn’t in the RedMart feed, OneCart receives the order without a sales amount attached. Any report that is based on revenue then has nothing to add up for that order, so the RedMart portion can appear as $0.
In short: the order arrives complete for fulfilment, but the money value is missing because RedMart didn’t send it.
This is important, so to be clear about what keeps working normally:
The only thing missing is the sales value (revenue) on those orders.
Because the revenue value is missing, RedMart can read as $0 in any report that totals sales:
You can review these under Business Analytics in OneCart. For example, your best and worst selling SKUs by quantity are at https://app.getonecart.com/reports/skus, and you can export a date range from Reports > Sales History. Note that quantity-based views still reflect RedMart orders correctly. It’s specifically the value-based figures that will be low until prices are loaded.
OneCart can load your RedMart price list and backfill your past RedMart orders so your analytics reflect real sales values, both going forward and historically.
To get this done:
Once your price list is loaded, RedMart sales values will appear in your revenue-based reports alongside your other channels.
Tip: Keep your price list handy and up to date. If your RedMart prices change later, send us the updated list so your reporting stays accurate.
Still have questions about your RedMart data? Reach out to us at hello@getonecart.com and we’ll be glad to help.