Profit margin Help

That shouldn't be a big problem.

The ebay sales can be loaded into a Sales table. The transaction ID field is the logical choice for the key field that will link it to the Shipments table and the Payments table.

Load the shipments data in a Shipments table that's linked with the Sales and Payments table using the transaction ID key.

Load the paypal payments data in a Payments table that's linked with the Sales and Shipments table using the transaction ID key.

All the customer information can be consolidated in a Customers table. Keep only a Customer ID key in the Sales table to link it with the Customers table.

Finally the Products table with the data from your database which is linked to your Sales table using the SKU ID field.

Make sure the key fields that are used to link the tables have the exact same case sensitive name in the tables that should be linked.

Hello Ohannis,

Hope you are doing well!

Please use below sample script which will join & load data from different sources and calculate the required field. You can modify the script as per your need.

SampleSales:
LOAD TransactionId, 
     SoldPrice, 
     eBayFees, 
     CustomerInformation AS eBayCustomerInformation, 
     SKU
FROM
SampleData.xlsx
(ooxml, embedded labels, table is eBay);
INNER JOIN
LOAD TransactionId, 
     CustomerInformation AS ShippingCustomerInformation, 
     ShippingFees
FROM
SampleData.xlsx
(ooxml, embedded labels, table is Shipping);
INNER JOIN
LOAD TransactionId, 
     CustomerInformation AS PaypalCustomerInformation, 
     PaypalFees
FROM
SampleData.xlsx
(ooxml, embedded labels, table is Paypal);
INNER JOIN
LOAD ProductCost, 
     SKU
FROM
SampleData.xlsx
(ooxml, embedded labels, table is DBDump);

Sales:
LOAD TransactionId,
     SKU, 
     SoldPrice, 
     eBayFees,
     PaypalFees,
     ShippingFees,
     ProductCost,
     ProductCost - (SoldPrice - eBayFees - PaypalFees - ShippingFees) AS Profit
Resident SampleSales;

DROP Table SampleSales;

Hope this will help. !

Regards!

Rahul