CJDropshipping Shipping and Item Costs Extracting as Excel

[berkeyazer]

Hello Dears,

I would like to ask your advice in order to figure out a way to calculate my costs for each sales.

I am using CJDropshipping auto fullfilment for my Shopify store.

I would like to have an excel file including my products' SKU number, sales price per SKU, purchasing price per SKU and shipping price per SKU.

I can easily download the excel files from '' Products '' page through Shopify and I have there SKU numbers, sales price and purchasing price.

However I am not able to use it properly because of 2 reasons;

1st) Purchasing price per item does not match 100% with the current item cost in CJDropshipping

2nd) File doesn't include the shipping costs 

and both above prices are updated time to time by CJDropshipping.

I tried to find a way to extract the data from CJ to match them with what I have from Shopify, in order to make sure I can follow the changes and I am applying my pricing policy accordingly.

However I could not find any way to exctract that data from CJDropshipping.

On the other hand, if I leave that item cost as not updated in my Shopify item costs field, I am afraiding if Shopify will give me incorrect profitability analysis at the end.

Therefore, I need your help to find a way to have the daily/in each 3 days/weekly basis updated data for Purchasing Price per SKU, Shipping Price per SKU including SKU Numbers from any kind of platform, or by using any additional program.

Please share your experiences with me,

Thank you very much for the support in advance.