Inventory handling
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=1879
Printed Date: 23-April-2025 at 11:07am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Inventory handling
Posted By: cpgmar
Subject: Inventory handling
Date 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.
-------------
Cindy
The Tasteful Garden
www.tastefulgarden.com
|
Replies:
Posted By: Hamish
Date 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.
-------------
Editing ProductCart Code?
See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code
|
Posted By: cpgmar
Date 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?
-------------
Cindy
The Tasteful Garden
www.tastefulgarden.com
|
Posted By: Hamish
Date 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.
-------------
Editing ProductCart Code?
See http://wiki.earlyimpact.com/developers/editcode" rel="nofollow - WIKI Guidelines for Editing ProductCart's ASP Source Code
|
|