Join our Premium Membership now and save with Xpres, Listawood, Ink Experts, Ink Express and more! Just £10 per year.....Click the Membership link above.....

User Tag List

Similar Threads

  1. Xpres Open Again!! - Online Orders Only
    By UK Printed Mugs in forum General Dye-Sub Chit Chat
    Replies: 6
    Last Post: 08-04-2020, 11:13 PM
  2. Shipping larger orders
    By Skarekrow in forum General Dye-Sub Chit Chat
    Replies: 2
    Last Post: 06-04-2018, 03:32 PM
  3. Desktop printer for orders
    By artygirl in forum Printers
    Replies: 9
    Last Post: 24-10-2016, 08:35 PM
  4. Organising orders
    By Oaten in forum Hints & Tips
    Replies: 3
    Last Post: 29-04-2014, 09:18 PM
  5. Where's your orders coming from?
    By Lee in forum General Dye-Sub Chit Chat
    Replies: 8
    Last Post: 21-08-2011, 01:14 AM
Results 1 to 9 of 9
  1. #1
    Premium Member
    Join Date
    May 2013
    Location
    London
    Posts
    628
    Downloads
    0
    Uploads
    0
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    How to manage all the online orders effectively

    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 ..

  2. #2
    Premium Member
    Join Date
    Nov 2011
    Location
    Bishop Auckland, County Durham
    Posts
    4,280
    Downloads
    0
    Uploads
    0
    Mentioned
    5 Post(s)
    Tagged
    3 Thread(s)
    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.

  3. The Following User Says Thank You to pisquee For This Useful Post:

    Ravisteam (12-05-2020)

  4. #3
    Senior Member
    Join Date
    Jun 2010
    Location
    Cambridge
    Posts
    2,369
    Downloads
    0
    Uploads
    0
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)
    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.

  5. The Following User Says Thank You to GoonerGary For This Useful Post:

    Ravisteam (12-05-2020)

  6. #4
    Senior Member
    Join Date
    Jan 2012
    Location
    Germany-NRW
    Posts
    1,281
    Downloads
    2
    Uploads
    0
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)
    Im following this post. Same problem.

  7. #5
    Premium Member
    Join Date
    Nov 2011
    Location
    Bishop Auckland, County Durham
    Posts
    4,280
    Downloads
    0
    Uploads
    0
    Mentioned
    5 Post(s)
    Tagged
    3 Thread(s)
    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.

  8. The Following User Says Thank You to pisquee For This Useful Post:

    Ravisteam (12-05-2020)

  9. #6
    Premium Member
    Join Date
    May 2013
    Location
    London
    Posts
    628
    Downloads
    0
    Uploads
    0
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by pisquee View Post
    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 .)

  10. #7
    Premium Member
    Join Date
    May 2013
    Location
    London
    Posts
    628
    Downloads
    0
    Uploads
    0
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by GoonerGary View Post
    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 ..!!

  11. #8
    Senior Member
    Join Date
    Jun 2010
    Location
    Cambridge
    Posts
    2,369
    Downloads
    0
    Uploads
    0
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)
    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.

  12. The Following User Says Thank You to GoonerGary For This Useful Post:

    Ravisteam (12-05-2020)

  13. #9
    Premium Member
    Join Date
    Nov 2011
    Location
    Bishop Auckland, County Durham
    Posts
    4,280
    Downloads
    0
    Uploads
    0
    Mentioned
    5 Post(s)
    Tagged
    3 Thread(s)
    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.

  14. The Following User Says Thank You to pisquee For This Useful Post:

    Ravisteam (12-05-2020)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •