Need to automatically update cart daily.

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

   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:  ggordon@garymgordon.com

IM:  garymgordon  (Yahoo and AIM) or  garymgordon@hotmail.com (MSN)  or 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.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
garymgordon Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 10-November-2006 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote garymgordon Report Post Thanks(0) Quote Reply Topic: Need to automatically update cart daily. Posted: 04-August-2007 at 12:40pm
	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: ggordon@garymgordon.com IM: garymgordon (Yahoo and AIM) or garymgordon@hotmail.com (MSN) or 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.

slinc Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 10-February-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote slinc Report Post Thanks(0) Quote Reply Posted: 10-August-2007 at 9:27am
	Since you are basically modifiing data from one datasource (.csv) to the Product Cart databaes (SQL) I would probably attempt it using a very complex SQL statement(s). Have this run as a scheduled job every day. This can be a little complicated and if you are not good with writing queries I recommend finding a developer that is. We have created some jobs that update our Product Cart from our Order Management system. Not quite as complicated as you need but have had good success with it. Just an idea.