Custom Volusion Price Update Automation with Volusion API
| Būsena | UŽDARYTA |
| Biudžetas | 501-1000 Eur |
| Sukurta: | 2014-09-10 |
| Baigiasi: | 2014-09-17 |
| Siūlo: | Nėra |
| Apibūdinimas: | DO NOT paste your boilerplate / canned resume - I will immediately eliminate your application if you do. I am looking for someone with excellent communication skills and that has some experience with Volusion's API. Ideal candidates will already have this site bookmarked (http://devwiki.volusion.com/) and have already had experience using the Voluson API in at least one other project. Please briefly describe that project. Situation: We have about 3000 active products on Volusion that we get updated pricing on every week and it is too much hassle to manually update all those prices so often. What we want: We want an external site built with PHP / MySQL that uses some custom coding using a lightweight PHP framework (like http://www.slimframework.com/ or http://fatfreeframework.com/auth) to: 1) allow a user to login (all users are admins and can add / edit / remove users 2) accept an uploaded XLS or XLSX file from a logged in user 3) place that file in a directory called "to-be-processed" 4) every day (at or near midnight), run a cron job to check that folder for an XLS or XLSX file 5) when a file is found to be in that directory, process it using 6) http://phpexcel.codeplex.com/ in order to process pricing updates to the Volusion site 7) on the external site you build, we will need the database to be able to keep track of the current active products on the Volusion site, and 8) keep track of product pricing updates and products that have no change, and 9) keep track of products that are no longer available 10) once the file has been processed into its separate table(s) as needed, run through and compare the prices of the Volusion site products with the newly imported Excel sheet. 11) at the end of the processing, send an email to all admins (that don't opt-out just add a checkbox to the "my account" page that says "yes, send me automated pricing update reports" that is checked by default) that contains: a) subject: [Volusion prices updated]: # updated, # not available, # no change b) with a basic report listing out when the report was run and c) (in red) how many and which products (link to them, if possible) need attention (not found in excel file, or some other problem) and d) (in green) how many and which product (link to them) prices got updated (and to what) and e) (in grey) how many products were found but needed no updates 12) move the excel file into an "archive" directory Here is the details on the excel file: It contains about 50,000 products, but only about 3,000 are active on the Volusion site. If a product exists and is active on the Voluson site, we want to keep track of its current state on the external site we are building with this job. If the price is the same in the Excel file as is on the Voluson site, somehow indicate that there was "no change" necessary in the database. If the price was NOT the same in the file and Volusion site, then we need to update the price on Voluson and indicate that the price changed in the database. If a product is NOT FOUND in the Excel sheet but is one of the active Volusion site products, please automatically de-activate it / hide it on the Volusion site (with the API) and indicate in the database that the product was "not available". Somehow we need to locally keep track of the current active products on the Voluson site. For example, if we decide to stop carrying a product as "active" one day, we don't need to keep its price updated. The Volusion site database of active products basically needs to be exported to a local database before the rest of the cron job runs. We also need to maintain a log (in the database, and create a CSV file for that day) of what happened with which products and when it happened. So, we can go back 3 weeks and see that: "2014-08-10", "3409043" ,"no change" and the next day "2014-08-11", "3909043", "price increased from $4.50 to $4.55" This log file and database log will only be created when there is a file that is processed. When there is no file to process, there is no need for any logs. We would also like to sell more products in the future - so this automatic processing of about 3000 products is just the beginning - we hope to sell more than 10,000 products and update them all the same way by the end of this year. I will supply the domain and hosting, including cPanel access. What is your Skype Name? Google Hangouts name? Thanks for your time and for reading this detailed job posting. Do you have any questions for me? Posted On: September 10, 2014 00:52 UTC ID: 204510610 Category: Web Development > Web Programming Skills: Array, Array Country: United States click to apply 
|
| Darbo Tipas(ai): |
|
| Duomenų Bazė: | |
| Operacinė Sistema: | Linux |
| Siūlymų Skaičius: | 0 |
| Siūlosi | Žinutės | Kaina | Trukmė | Įvertinimas | Informacija |
|---|
