Custom Export Needed For Warehouse Fulfillment

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hello,

I just wanted to get some idea of what can be done to integrate my PC orders and backend with my new warehouse's order fulfillment system.  I guess I may need some sort of custom report that can be exported each day and sent to my warehouse so they can process and ship my daily orders, however, once they do outside of PC, my backend will be useless because all the shipping data will be processed outside of PC....SO....I was wondering if there was a way to not only export the data from PC to an Excel spreadsheet but then have the warehouse email me back a spreadsheet so I can update my backend and we're both on the same page.  The warehouse would report back things like tracking numbers and ship date and what not.

Below are the fields my warehouse requires all in one row in a spreadsheet.  Can this data be extracted in this format from PC?

Thanks!

Customer Email 
Billing Company 
Billing First Name 
Billing Last Name 
Billing Address 1 
Billing Address 2 
Billing City 
Billing State ID 
Billing State 
Billing Zip 
Billing Telephone 
Billing Country 
Shipping Company 
Shipping First Name 
Shipping Last Name 
Shipping Address 1 
Shipping Address 2 
Shipping City 
Shipping State 
Shipping Zip 
Shipping Telephone 
Shipping Country 
Shipping Service Selected  
Order Sub Total 
Discount Code Used 
Discount Total      
SKU1 
SKU 1 Quantity 
SKU1 Cost 
SKU2 
SKU2 Quantity 
SKU2 Cost 
SKU3 
SKU3 Quantity 
SKU3 Cost 
Etc, Etc…for all SKU's purchased for each customer.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
nasdaqphil Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15-July-2010 Status: Offline Points: 0	Post Options Post Reply Quote nasdaqphil Report Post Thanks(0) Quote Reply Topic: Custom Export Needed For Warehouse Fulfillment Posted: 16-July-2010 at 2:24pm
	Hello, I just wanted to get some idea of what can be done to integrate my PC orders and backend with my new warehouse's order fulfillment system. I guess I may need some sort of custom report that can be exported each day and sent to my warehouse so they can process and ship my daily orders, however, once they do outside of PC, my backend will be useless because all the shipping data will be processed outside of PC....SO....I was wondering if there was a way to not only export the data from PC to an Excel spreadsheet but then have the warehouse email me back a spreadsheet so I can update my backend and we're both on the same page. The warehouse would report back things like tracking numbers and ship date and what not. Below are the fields my warehouse requires all in one row in a spreadsheet. Can this data be extracted in this format from PC? Thanks! Customer Email Billing Company Billing First Name Billing Last Name Billing Address 1 Billing Address 2 Billing City Billing State ID Billing State Billing Zip Billing Telephone Billing Country Shipping Company Shipping First Name Shipping Last Name Shipping Address 1 Shipping Address 2 Shipping City Shipping State Shipping Zip Shipping Telephone Shipping Country Shipping Service Selected Order Sub Total Discount Code Used Discount Total SKU1 SKU 1 Quantity SKU1 Cost SKU2 SKU2 Quantity SKU2 Cost SKU3 SKU3 Quantity SKU3 Cost Etc, Etc…for all SKU's purchased for each customer.

nasdaqphil Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15-July-2010 Status: Offline Points: 0	Post Options Post Reply Quote nasdaqphil Report Post Thanks(0) Quote Reply Posted: 16-July-2010 at 2:27pm
	I forgot to add, obviously I would need to export this data by date purchased or by "order processed status" - In other words, I must know what did ship and what did not ship so I don't duplicate orders and miss others. Each morning this would be updated and exported only with the orders from the day before that have not been shipped yet. Thanks again.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 16-July-2010 at 3:04pm
	Phil - I directed you to the custom export features in the admin. Never heard if you had examined that feature.

nasdaqphil Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15-July-2010 Status: Offline Points: 0	Post Options Post Reply Quote nasdaqphil Report Post Thanks(0) Quote Reply Posted: 16-July-2010 at 3:25pm
	Yes, I did check it out and there is no single report that does what's needed from what I can tell. I can get bits of the required info from different reports but its not all there, sortable by order date, and would require a bunch of work each day to get the data into a useable format. I want to make sure we are not hand-pulling data and physically manipulating it for the reports each morning because we will introduce human error and screw up the daily orders. My old warehouse processed daily orders from MY backend and then updated their systems afterwards. This new warehouse wants to do it the other way around.

intour Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 30-June-2006 Location: United Kingdom Status: Offline Points: 0	Post Options Post Reply Quote intour Report Post Thanks(0) Quote Reply Posted: 17-July-2010 at 3:40am
	Productcart has extensive reporting facilities built in but if these don't meet your requirments it is possible to pull out any data you want and display it in any order. It may need to be done for you as a customised feature. There are people here, including myself, who can do this. Nigel Edited by intour - 17-July-2010 at 3:40am
	Innerview Productcart Platinum Reseller Web Design/Hosting/Virtual Tours