Advice on way to update stock, quantity and pricing

[cheekymang]

Hey Guys,

I'm wondering if anyone has any good recommendations/ideas/experience with updating stock.

I have around 1400 products. Pretty much 95% of them have a reduction on their price using a specific price rule (no specific groups or anything just a general amount off different for each product in dollar amount)

 

I currently update each products quantity,price and price reduction amount (thats all I update) with a CSV sheet I generate using filemaker. I have also found a way to update the pesky combination products using filemaker and a convoluted file system.

 

Unfortunately, I have the horrible bug (I'm on 1.5.3.1) that means every time I update, I have to truncate the specific price rule table in MYSQL as the csv import doesn't update specific price rules. It creates new ones and its horrible.

 

My question is this : The point of sale system where my physical shop is can generate me a csv file, that has on it everything I need; price, reduction amount and current quantity, and each product in the store has a unique reference ID (also on the sheet)

 

Can anyone recommend another way to update selected stock information in prestashop without the cumbersome and time sapping csv sheet import and SQL table dropping I'm doing in the back of prestashop?

Can this be done with a "direct connection" (somehow) to my database? 

 

If anyone could recommend some posts or reading material on this, or could tell me how they like do it would be most appreciated. 

Surely there is a simpler way than generating CSV sheets, filtering them, loading them into csv import....all that horrible stuff! Oh yeah! I also have to split my sheets as it times out. Im sure everyone is used to that too!

Thanks for reading, cheers.

 

 

 

 

[jsdg86]

TTT