improved
Transformation
Added shipping_cost and fulfillment_cost to uos.sales_report table
We have added 2 new columns to the uos.sales_report table:
shipping_costs
and fulfillment_costs
.This is an update to the structure of the table, so any Enterprise merchants with custom scripts that push data into the uos.sales_report table will need to be updated to use the new table structure.
After the update, this will be the structure of uos.sales_report:
transaction_id
, store_transaction_id
, transaction_date
, transaction_type
, transaction_detail_type
, store_name
, store_type
, store_country
, store_integration_name
, business_unit
, business_channel
, customer_id
, store_customer_id
, email_address
, order_id
, store_order_id
, order_date
, refund_date
, order_code
, giftcard_only_order
, order_line_id
, store_order_line_id
, store_product_id
, store_variant_id
, original_currency
, currency_conversion_rate
, converted_currency
, product_name
, listing_sku
, sku
, quantity
, price
, gross_sales
, discount_amount
, shipping_amount
, fulfillment_amount
, shipping_cost
, fulfillment_cost
, tax_amount
, refund_amount
, net_sales
, sku_cost
, duties
, __shop_id
, __uos_integration_id
, __loaded_at
, __synced_at