Everything you need is in this folder: S:\Normans Web & Catalogue\Channel Advisor\Shipping Update

You'll need a login to Channel Advisor.

  1. Go to Channel Advisor>Fulfill>Orders
  2. Filter By: Ready to Ship

Alternatively, Click Here for Ready to Ship Orders to Download

  1. Export All Invoice Information

Unselect all selected tick boxes, and reselect the following:

  • Invoice ID
  • Shipping Class
  1. Click “Export”.
  2. Go to File Export Center
  3. Click “Download” on file you just generated in CA
  4. Open the .zip
  5. Open the Excel
  6. Open the CAShipFilePrep Macro from the following folder: S:\Normans Web & Catalogue\Channel Advisor\Shipping Update
  7. Copy and paste all of the data from the spreadsheet downloaded from Channel Advisor to the CAShipFilePrep Macro spreadsheet into the columns A, and B.
  8. Click Enable Content in the Security Warning at the top of Excel
  9. Click the 1. Prep for CA button
  10. Log into Q&A
  11. Relaculate the worksheet
  12. Delete any rows that have 0 in the shipped date column
  13. Log out of Q&A
  14. Set Calculation Options back to Automatic
  15. Click 2. Delete Column D button
  16. Go to File>Save As> S:\Normans Web & Catalogue\Channel Advisor\Shipping Update\Archive
  17. Save the file as a Text (Tab delimited)
  18. Click here 
  19. Click Choose File
  20. Navigate to the file you just create in : S:\Normans Web & Catalogue\Channel Advisor\Shipping Update\Archive
  21. Click Open

Done!