How to manage all the online orders effectively

[Ravisteam]

HI guys this is probably a complicated question , how do you guys record orders and fullfill them daily ..we use google drive , make folders for every order with content related to it .But this seems time consuming ..Google back up and sysnc take ages to sysnc at the begging of every morning (we use the desktop version ) , , never tried any other solutions ..Do you guys have any good solutions to manage personalized orders specially from ebay , etsy etc ..

[pisquee]

We save all orders with their order number as the filename, these are saved on large network shared NAS drive. The orders folder is for the year, with a folder for each month, in which is a folder for each day for when the design file is made/saved.

[GoonerGary]

Quite basic really. Download the csv file for that day.
Copy and paste the product title and customer shipping name columns into a new spreadsheet.
Copy and paste the personalised details into a column and any gift notes.
Print transfers, print shipping labels.
Then use that same spreadsheet to pack the orders.

[Earl Smith]

Im following this post. Same problem.

[pisquee]

Aside from saving the designs (above)
Start of the day all the orders forums are printed off from the different sales platforms, and then those papers are used for the staff to process the orders.

For things that are in stock, they just go straight to the packing bench
All others go to the Photoshop desk, and the staff work through printing off the transfers.

For orders which involve small components, a sticky invoice enclosed type clear envelope (free from RM!) gets stuck to the front of the form - the transfer will go in here, along with any small components for the order

Once sent to the print queue, the photoshop staff then put the page into a set of intrays next to the printer - each product type has its own in trays, and the production staff pick the forms out from there for what they're working on

Then depending on how busy they are they either keep them as a pile, or put them on noticeboards in the room they are working in to keep track.

Once an order is complete, its taken to the packing bench in the warehouse, and then the order from helps the packer find the order in click and drop and get it despatched.

For NOTHS orders, the order form has the order number in barcode form - so we have barcode scanners at the photoshop computer for saving the filename as the order number, and at the packing bench for using with click and drop.

[Ravisteam]

Aside from saving the designs (above)
Start of the day all the orders forums are printed off from the different sales platforms, and then those papers are used for the staff to process the orders.

For things that are in stock, they just go straight to the packing bench
All others go to the Photoshop desk, and the staff work through printing off the transfers.

For orders which involve small components, a sticky invoice enclosed type clear envelope (free from RM!) gets stuck to the front of the form - the transfer will go in here, along with any small components for the order

Once sent to the print queue, the photoshop staff then put the page into a set of intrays next to the printer - each product type has its own in trays, and the production staff pick the forms out from there for what they're working on

Then depending on how busy they are they either keep them as a pile, or put them on noticeboards in the room they are working in to keep track.

Once an order is complete, its taken to the packing bench in the warehouse, and then the order from helps the packer find the order in click and drop and get it despatched.

For NOTHS orders, the order form has the order number in barcode form - so we have barcode scanners at the photoshop computer for saving the filename as the order number, and at the packing bench for using with click and drop.

.

Hi Tim , We also use this Folder system to save orders on google drive ...

But I have few queries for you ..

When you print designs for orders , do you print any reference in that printed sheet .. ?
Example if you print a cushion cover for a customer how do you know which is which ...(We have to check on the computers to match the orders when sticking the postage labels (Packing ) , and I think its wasting time .)

[Ravisteam]

Quite basic really. Download the csv file for that day.
Copy and paste the product title and customer shipping name columns into a new spreadsheet.
Copy and paste the personalised details into a column and any gift notes.
Print transfers, print shipping labels.
Then use that same spreadsheet to pack the orders.

-So don,t you have folders for each customer ?. If not how you know custom details for that particular order ?.
cos on eBay , etsy ppl buy 1st and send pictures later , some times few days later ...

-When you print the transfer sheets ,again how do you know what order they belong to ?. so do you print a reference on every design you print ?.

- We seems to waist so much time for matching orders specially packing ..We have to go thought a PC to match the designs ..Never found a easy solution for this ..!!

[GoonerGary]

I don't print customer images, so I know all of my products by their title. But if I had a customer design or a variation of a product, there would be a column in the spreadsheet detailing the name of the image. If it were a customer image, i might call it 'puffin and sea', 'wedding kiss sunset' 'spitfire plane' in the spreadsheet. Grab the spitfire mug and pack.

[pisquee]

For orders that require it, the order number is printed on the transfer.
and then the order form follows the transfer/product around the building until complete and ends up at the packing bench.