Order COGS Issues

Having trouble with order COGS calculations? Here are solutions to common problems.

COGS Shows $0

Problem: Orders show $0 for Cost of Goods Sold.

Solutions:

1. Check product costs - Ensure costs are set for products in the order
2. Timing matters - Costs must be set before or at order time
3. Sync status - Trigger a manual sync to refresh order data
4. Variant matching - Verify costs are set at the correct variant level

Incorrect COGS Amount

Problem: The COGS calculation seems wrong.

Solutions:

1. Verify product costs - Check each product's cost in the order
2. Check quantities - COGS = Quantity × Unit Cost for each item
3. Review cost history - Historical costs are used for older orders
4. Check costing method - FIFO/LIFO/Average affects which costs are used

Orders Missing from Dashboard

Problem: Some orders don't appear in CostSync.

Solutions:

1. Wait for sync - New orders may take up to 15 minutes to appear
2. Check order status - Only completed orders are included by default
3. Date range - Verify your date filter includes the order date
4. Manual sync - Click Sync to force immediate update

Historical Orders Wrong

Problem: Old orders have incorrect profit calculations.

Solutions:

1. Cost timing - Historical orders use the cost that was set at order time
2. Recalculate option - Some plans allow recalculating historical COGS
3. Cost updates - Updating costs doesn't retroactively change old orders (by design)

Refunded Orders

Problem: Refunded orders still show in profit calculations.

Solutions:

1. CostSync accounts for refunds automatically when synced
2. Partial refunds adjust revenue proportionally
3. Check the order detail to see refund handling
4. Sync to ensure refund status is current

Multi-Currency Orders

Problem: Orders in different currencies have wrong COGS.

Solutions:

1. All COGS are calculated in your base currency
2. Verify exchange rates were correct at order time
3. Check supplier currency settings
4. Contact support for currency-specific issues

Discount Handling

Problem: Discounted orders don't calculate correctly.

Solutions:

1. Revenue = Order total after discounts
2. COGS = Full cost of products (discounts don't reduce your costs)
3. Profit = Discounted revenue - COGS
4. Heavy discounts may result in low or negative margins

Order Detail Discrepancies

Problem: Order details in CostSync don't match Shopify.

Solutions:

1. Sync may be delayed - trigger manual sync
2. Check for recent order modifications in Shopify
3. Some order details are snapshot at sync time
4. Contact support if significant discrepancies persist

Still Having Issues?

Contact support with:

• Order number(s) affected
• Expected vs actual COGS
• Screenshots of the order in both CostSync and Shopify