Automate Opencart site price and stock updating from supplier database

Closed

Description

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

Skills: eCommerce, HTML, MySQL, Shopping Carts, Website Design

See more: 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, opencart link, update stock, asp stock, updating website html, live update price opencart

Project ID: #5161748

Awarded to:

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 : http://47stphoto.com/ http://donbebi More

$83 USD in 3 days
(34 Reviews)
6.1

12 freelancers are bidding on average $169 for this job

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: http://sigma-dns.sigmavirtual.com/PDemo1/Am More

$154 USD in 3 days
(97 Reviews)
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 More

$88 USD in 3 days
(123 Reviews)
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 More

$244 USD in 5 days
(24 Reviews)
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 in 10 days
(50 Reviews)
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 in 7 days
(145 Reviews)
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 More

$217 USD in 7 days
(38 Reviews)
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 More

$128 USD in 5 days
(40 Reviews)
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. http://yorkshirepetsupplies.co.uk/ http://orderyourstationery.com/index.php http: More

$152 USD in 3 days
(24 Reviews)
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 More

$115 USD in 4 days
(17 Reviews)
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 More

$155 USD in 3 days
(25 Reviews)
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 More

$200 USD in 3 days
(10 Reviews)
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 More

$100 USD in 5 days
(2 Reviews)
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 More

$155 USD in 3 days
(0 Reviews)
0.0
RedMapleMedia

A proposal has not yet been provided

$222 USD in 3 days
(0 Reviews)
0.0