Zen Follower
- Join Date:
- May 2008
- Posts:
- 203
- Plugin Contributions:
- 0
The way I handle shipping is a mess!
- Receive orders, either via paypal or google checkout
- Pull items ordered and shipping method from the first part of the orders page, since copying the items from the section on the right provides one clean cell of information I can paste into excel, instead of pasting into multiple cells if I copy from the more detailed page.
- Paste this info into a row on excel
- Go back to browser, click on order again to see more details
- copy shipping address
- paste into another cell on the same row in excel
- repeat until all orders are in an excel spreadsheet
- copy all rows of information
- open notepad, paste information
- add appropriate spacing. Two lines between items ordered and shipping method, then construct a valid shipping address from each customer since the text I just pasted is all arranged in one line initially.
- Once I'm done with this, copy all, paste into a word document.
- Copy international addresses, paste a second copy of this address beneath the first, so I can cut and tape this to a customs form later
- Print word document (basically shipping addresses with itemized list and shipping method above each)
:shocking::shocking::shocking:
Please... help me.