|
I am trying to find out the best way to accomplish a particular need that I have. I'm not sure if something already exists that I can use, or if I need something to be custom written. But here's the situation.
My client has a store in ProductCart. They have a POS system that runs on their registers that tracks all sales, inventory, prices, sale prices, etc., etc. When sales are made, everything is tracked in the POS system.
The company that manages the POS system can export a daily file and FTP a .csv file to my server each night.
I then want a script, etc. to take that .csv file that will always be in the same location, in the same folder on the server and ... have the data update the ProductCart store in various ways.
1. New products that may have been added, will need to be added into Product Cart automatically, including the price, name, etc., etc. (all relevant fields).
2. Price changes on all of the previous items that were in the shopping cart will need to be updated.
3. If any items have a SALE price indicated (since some do not and some .. periodically go on sale for a month or so) will need to be updated so they display in Product Cart as "on sale" and also display the SAVINGS amount (as Product Cart currently does). Sale items typically have a start date and end date. So, if there's a start date and end date in the appropriate fields, the sale price will be displayed. If the date has passed or if no dates are shown, then the item will not be considered on SALE.
4. All items on Sale would appear under the SPECIAL section in Product Cart, while they are actively ON SALE. Only items that are ON SALE would appear under the Special section, unless the client specifically and individually tags an item (from within Product Cart) to be displayed in the SPECIAL section.
Basically, this needs to run daily on a particular schedule.
I need to know what would be the most cost efficient manner to get this done and what suggestions someone might have.
If a custom script is going to be needed, I need a quote for the work so it can be considered.
Please contact me by IM, Email or by phone.
Thanks,
Gary Gordon
Email: mailto:ggordon@garymgordon.com - ggordon@garymgordon.com
IM: garymgordon (Yahoo and AIM) or mailto:garymgordon@hotmail.com - garymgordon@hotmail.com (MSN) or mailto:garymgordon@gmail.com - garymgordon@gmail.com (Google Talk)
PHONE: 1-856-482-8320 (in the USA - New Jersey) If you are located in the USA, I will gladly call you back to discuss this further.
|