Create .csv bulk order upload file to Spoonflower
Approved plate and DISPLAY .png's must be uploaded to Spoonflower before ordering.

After downloading approved payment orders.xml file to local Mac:

  1. Open bulk_order .xml file from within Excel.
  2. If there are DISPLAYS and/or Fun Size ordered, cut/paste Columns Q-V (DISPLAY) and W-AB (Fun Size) into Columns A - H in the day's Bulk_deisgn .xml file.
  3. Cut/paste DISPLAY item info from bulk_order .xml columns F-I (DISPLAY) and columns K-N (Fun Size) into bulk_order .xml columns A - D. Also copy plate # from Column J or P into the same respective rows with newly pasted Columns A - D DISPLAY/Fun Size info.
  4. Sort rows by Column J or P as appropriate so that plate/DISPLAY/Fun Size for the same plate #s are consecutive in the upload to Spoonflower.
  5. Copy and paste Columns A through D from .xml file to GoogleDocs Spoonflower_Order_Uploader worksheet.
  6. Choose File>Download as Comma-separated values. Never open this csv file.
  7. Upload the Kona_Designs_Plate_Uploader.csv file to Spoonflower.
 
 
Click here to load this Caspio Cloud Database