we have 10 excel file with different different header and 1 master file.
i want mapping of these excel file with online php website.
[url removed, login to view] attached as a master file.
these file are sale file from amazon / flipkart etc etc.
i need mapping +
SKU Mapping (we have master sku and then it give us option to mapping sku).
we need sku mapping due to ecommerce because some time when i sell same item with different different name so we map it master .
we need :
1 : we need excel file mapping
2 : sku mapping file
3 : we need excel file total sku report after mapping date wise option. Date required day/date to and from option with unlimited date.
4 : sale data / return data / cancel data / channel ledger wise.
5 : Please check column X. i need you can check - final amount of invoice and deduct tax amount and this column come. sometime tax show 0 which is not possible and need to correct.
6 : Please check column Y. we want u can set here "Local GST 12% " / "Local GST 18% " "Local GST 5% " or add option other also. "IGST Sale 18%" "IGST Sale 12%" "IGST Sale 5%". our excel file show tax amount but ledger wrong show. so i need correct ledger.
amazon recd file attached which need to set/map in [url removed, login to view] with our requried point correction.
i need demo before award.