https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 17:51:55 +0000 Wed, 06 Aug 2008 05:43:21 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=1879 https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ https://forum.productcart.com/inventory-handling_topic1879_post6312.html#6312 Author: Hamish
Subject: 1879
Posted: 06-August-2008 at 5:43am

Hi Cindy,
    In the Custom Data Export you can select delivery date as one of the fields and also export the data as a CSV or Excel.  When you have the data in excel you will then be able to sort it any way you wish.
As you need to do this very regularly I think it's definitely worth looking into :-
- Making this a fixed report you can run on demand without selecting the fields and formats.
OR
- Using an XML based solution as you will reduce the effort required each day and reduce the risk of duplicating data.
]]> Wed, 06 Aug 2008 05:43:21 +0000 https://forum.productcart.com/inventory-handling_topic1879_post6312.html#6312 https://forum.productcart.com/inventory-handling_topic1879_post6311.html#6311 Author: cpgmar
Subject: 1879
Posted: 05-August-2008 at 11:09pm

The custom data export will only send information about products sorthed by when they are ordered but not by when they are scheduled to be shipping, again, we may not ship for several months. 

Stone edge is not really for me, tried that already.  More trouble than it is worth.

The XML integration may be worth checking into...

We have modified the Sales Report by Product to include the expected shipping date range but I cannot export it as a CSV file like some of the other reports, it is only html.  Can that be fixed easily?
]]> Tue, 05 Aug 2008 23:09:22 +0000 https://forum.productcart.com/inventory-handling_topic1879_post6311.html#6311 https://forum.productcart.com/inventory-handling_topic1879_post6309.html#6309 Author: Hamish
Subject: 1879
Posted: 05-August-2008 at 8:50pm

Hi Cindy,
Does each order have a single future delivery date?

The custom data export allows you to select all the info you need if the standard order report doesn't suffice.
Fancier solutions include :-
- custom coding a PC page.
- Using the XML integration (I'm aware of it but not used it yet).

- Perhaps Stoneedge Order management will meet your needs - see the "Add-ons" from the main EA website. 
]]> Tue, 05 Aug 2008 20:50:03 +0000 https://forum.productcart.com/inventory-handling_topic1879_post6309.html#6309 https://forum.productcart.com/inventory-handling_topic1879_post6308.html#6308 Author: cpgmar
Subject: 1879
Posted: 05-August-2008 at 6:36pm

We have products that will be ordered over several months and will be scheduled to ship sometime within a 15 week period.  ie. I may order in December to have my products shipped in May. 

I am looking for some help to develop an inventory handling report that can be easily managed by exporting data from PC for each week of shipping throughout the 15 weeks or pulling data from my MS SQL database sorted by shipping week into an existing excel spreadsheet.  Another option is to create a spreadsheet that will have a macro to fetch the info from the exported file. I will use the spreadsheet to keep track of inventory in/out and QOH throughout the 15 weeks.  I am manually entering the sales data now from the PC Sales Reports for each date range which takes too much time and is easy to make mistakes with the data entry.

Anybody have any ideas about how to either modify PC to export CSV data to this spreadsheet or build a separate report in another program by pulling info from the database.  If you have a good easy solution, let me know.  I am willing to pay for the programming to make this work.
]]> Tue, 05 Aug 2008 18:36:15 +0000 https://forum.productcart.com/inventory-handling_topic1879_post6308.html#6308