Completado

Automate Opencart site price and stock updating from supplier database

Good day

I have an Opencart E-Commerce website selling computer products.

My supplier gives me a link into their database for stock pricing and availability.

[url removed, login to view]

If I put in my username and password along with the stock code (stock code to be found in my opencart database) I am looking for it gives me a return like this:

<?xml version="1.0"?>

-<payload> -<header> <version>2</version> <modified>2013/11/24 06:32:46 AM</modified> <ttl>727</ttl> </header> -<products> -<product> <code>WC-CH100I</code> <description>Corsair H100i wc+ corsair-link</description> <price>1299</price> <stock>No</stock> </product> </products> </payload>

From here I need the price value and stock value imported to my site database so that if the prices change or the item becomes out of stock it will adjust on my site automatically when the script is run.

The price will have a fixed markup added.

If stock = yes then qty in opencart database should updated to qty of 5.

If stock = no then qty in opencart database should be updated to qty of 0. This will show the item out of stock.

If the item cannot be found from the query (it has been deleted by the supplier) then it should be set to disabled in my opencart database.

There are +-7000 products that must be updated each time the script is run.

After the script has run I should be emailed letting me know the script has run and telling me how many products had to be updated.

Option1:

The update script should run once every 24 hours automatically and I receive email confirmation once it has finished running.

Option 2:

The update script should run once every 24 hours automatically and I receive email confirmation once it has finished running.

+

I have also heard that if a customer clicks on an item it is possible that as the page opens this same query is performed, thereby having up to the minute pricing and stock availability. No need for individual item email updates.

Please give me a set price for both option 1 and option 2.

Kind regards

Terry

Habilidades: Comercio electrónico, HTML, MySQL, Carritos de compras, Diseño de sitios web

Ver más: opencart update stock database, website price value, product supplier database, product design supplier, please give me my password, html code for e commerce website, give me a username and password, e commerce how to set up, design price and product page, database design prices, abc 11, xml supplier, stock update, run and update, how to design my website like abc, fixed price html email design, automate email, opencart live price update option, code script link description, page found opencart

Información del empleador:
( 2 comentarios ) Somerset West, South Africa

Nº del proyecto: #5161748

Adjudicado a:

crystalcloudteam

Option 1 : 80 USD Option 2: 180 USD We can do it with all the features as required by you,Will provide full support. Also check the URL's for sample Ecommerce Websites : [login to view URL] http://donbebi Más

$83 USD en 3 días
(34 comentarios)
6.1

12 freelancers están ofertando el promedio de $169 para este trabajo

SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [login to view URL] Más

$154 USD en 3 días
(97 comentarios)
7.0
shambhal

hi there Maximum opencart reviews. The price is for option 1 , could not understand what you tried saying in option 2 You can check my reviews they are mainly modx and opencart based. I am the one who has got most o Más

$88 USD en 3 días
(123 comentarios)
6.4
snehaworks

Hello, I have gone through the description, current bid price is for option2. For option1 it will cost 20$ less. We have done similar thing in past as well so we know how to do code for both options, anyone you choo Más

$244 USD en 5 días
(24 comentarios)
6.3
techwelfare

hi we could do it perfectly with accuracy, please let us know if you want any clarification. if you want us to share our skill and previous work please initiate the chat..

$245 USD en 10 días
(50 comentarios)
6.2
AndrwProjects

Hi tnt1980. I think this all possible. Regarding option 2, so it matter of some delay before users get the page, if I understand you correctly.

$150 USD en 7 días
(145 comentarios)
6.1
innovativetech3

My Pleasure, Terry have a very pleasant evening..!! lets just move to your project please Just check us here first then we can discuss it more we are group of professionals and We do rather splendid websites and desig Más

$217 USD en 7 días
(38 comentarios)
5.8
yanotcook

I have completed this API integration with Opencart similar to your request: PayPal REST API code module for Open cart https://www.freelancer.com/projects/Website-Design-Shopping-Carts/Code-module-for-Open-cart.html Más

$128 USD en 5 días
(40 comentarios)
5.2
phpmysqlrocks

Hello sir, i have more than 4 years work with opencart. Ready to work with you, thanks! please check my opencart development. [login to view URL] [login to view URL] http: Más

$152 USD en 3 días
(24 comentarios)
5.0
searcheverything

Hi, I have gone through the requirement and below is the key elements which needs to be done: - Create a script which will check the username, password and the stock code in our website database and update the re Más

$115 USD en 4 días
(17 comentarios)
5.0
topworkerbd

sir I have three years of experience in opencart installation, theme devlopement,module development,bug solving,customization etc.I also work prestashop,zencart,Javascript,php,mysql.I am hard worker and ready to take Más

$155 USD en 3 días
(25 comentarios)
4.4
worldofharry

Hello, We are experts in Opencart and have our own extensions developed and up for sale. I have understood the requirement and can get this done soon. $200 for Option 1 $300 for Option 2 (if supplier provides i Más

$200 USD en 3 días
(10 comentarios)
3.9
asiandevelopers

http://www.freelancer.com/u/asiandevelopers.html. I am independent and professional developer. quality is guaranteed. My completion rate is always 100% and i feel proud for this. I am really interested with your projec Más

$100 USD en 5 días
(2 comentarios)
0.0
itgalaxyltd

Hi, I am professional Programmer & designer of Front end & Back end, I am working with challenge and hope to improve future plan with good network every client. If you want to get more faster job services with save ti Más

$155 USD en 3 días
(0 comentarios)
0.0
RedMapleMedia

A proposal has not yet been provided

$222 USD en 3 días
(0 comentarios)
0.0