Historical Average Shipping Cost Exports

Historical Average Shipping Cost calculates the mean actual cost paid for shipping a specific SKU based on historical fulfillment data. This value is stored at the inventory variant level as avg_shipping_cost and is designed to be exported to third-party repricers, ensuring your channel pricing remains competitive while covering actual logistics expenses.

To ensure the average is accurate and representative of a single item's shipping cost, Flxpoint applies specific filters to the data used in the calculation:

• 120-Day Window: The average is calculated using shipment data from the last 120 days.

• Single-Item Orders: Only orders containing a single line item with a quantity of 1 are included.

• Bundle Support: Flxpoint bundles are included in the calculation if a single quantity of the bundle is ordered without any other items.

• Automatic Updates: The average is recalculated automatically every time a new shipment is saved in the system.

You can manually manage the shipping cost value if you need to deviate from the calculated historical average.

• Manual Override: Enter a specific shipping cost to be used for a variant regardless of historical data.

• Locking: Lock the value to prevent the automated 120-day recalculation from updating the field.

• Removal: You can remove a lock or override at any time to return to the automated calculation logic.

This feature is primarily used for high-volume marketplace retailers who need to sync data to repricers via FTP or HTTP CSV imports. When configuring your automated export, you can include the following fields:

Note: This feature requires a specific feature flag to be enabled on your account. Contact your account manager to discuss enabling this functionality.