Post by sytra » Thu Dec 04, 2014 12:36 am

Hi,

We are using OC 1.5.5.1 and have a supplier stock feed that updates a few times a day, however when it does update it doesn't always set 0 stocks to out of stock and we have to run an SQL command.

The command we are using is this:

Code: Select all

UPDATE oc_product SET stock_status_id = '5' WHERE quantity = '0'
Is it possible to use VQmod to run the SQL query and if so how would I write the above code into an XML file?

Thank you for your help.

Running OC 1.5.5.1 with vqmods.
http://www.aislings.co.uk
http://www.lovers-paradise-toys.co.uk


Active Member

Posts

Joined
Sat Feb 04, 2012 6:27 am

Post by uksitebuilder » Thu Dec 04, 2014 4:17 pm

There should be no reason that the script that receives the supplier stock feed should not also be able to run that sql command after it completes

vqmod will be of no use

ImageImageImageImageImage

For Friendly Professional Support - Click Here


User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom
Who is online

Users browsing this forum: No registered users and 7 guests