SELLER RECORDS / PRODUCT COSTS
Keep costs tied to a date.
Record SKU costs with an effective date so a price change does not rewrite old results.
Session-only records
SKU COST RECORDS0
One row per marketplace SKU and effective date.Costs are not applied to older reports automatically. MARKETPLACE ADAPTERS / 03
COST CATALOG
Add a product cost
Use one SKU per marketplace mapping. Add a new dated record when the cost changes.
Costs stay separate from marketplace charges. GST input credits and packaging costs are not inferred here.
PRODUCT COST HISTORY
Saved SKU records
No SKU costs yet.
Add the exact marketplace SKU and the date its purchase cost became active.
Current costs do not change old calculations.This catalog preserves cost history. Linking each historical order to the cost active on its order date is a later calculation step and is not inferred in this version.