Automate Opencart site price and stock updating from supplier database
$30-250 USD
已完成
已发布超过 10 年前
$30-250 USD
货到付款
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.
[login to view URL]
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
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]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
Other Websites:
[login to view URL]
[login to view URL]
[login to view URL]
Best Regards
Crystalcoudteam
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..
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 records as per the condition provided in the requirement.
- upon successful run of the script we need to send the email. this is case when we run the script via the scheduler.
We can run the script as per your second choice as well at run time. but this might take a bit of time as compared to the first option.
However I can do for both the option and the estimated cost for each are as follows:
option 1: 110 USD
option 2: 130 USD.
Please let me know if you have any query.
Ready to start the work.
Regards