Home » Portfolio » Macro Writing Examples » Excel vba macro for the import of order draw down exports from X-Cart or Shopify into Royal Mail or DPD

This macro takes order draw downs from Shopify or X-Cart and formulates them for import into a Royal Mail or DPD shipping import templates.
Firstly the the macro begins combining orders with the same order ID's, separates orders if weight exceeds a weight threshold or is excluded. Next the orders are separated into various delivery service types. If weight exceeds threshold when combined during separation delivery service method is upgrade. The macro is designed for use with .csv files which is a standard draw down option for e-commerce systems. This macro can be altered to suite.