We require a Opencart specialist to make us a custom module/extension that can run along side our current website set up.
Here is what we require the module/extension to do:
Login to vendor ftp => import full csv data feed using ftp details =>
changable global settings (have all out of stock products from vendor appear as out of stock, minimum order quantity, subtract stock, status of the product, weight class, length class, tax class, customer group, option to add categories to top website menu/side category menu'
delimiter that is used to split categories into sub categories.
Option to have downloadable remote images
Next step is to have the mapping set up to adjust the data within the vendor feed into the website data
so this part should be able to put all vendor category products into website category products by replace all vendor categories with website categories.
Also should be able to add a % margin to vendor price
Next is the mapping of each heading from vendor to website e.g
vendor description heading will go into 'description'
Vendor quantity will go into QTY
Vendor UPC should go into EAN
and so on....
Next will be the final stage of import
What to do with the store when running import?
What to do with New Items?
What to do with existing items?
What to identify each product by: UPC or Model or SKU
Import images from vendor websites and rename them
Import specified product description relating to vendor items into website e.g spec of item, breif description of item (ICECAT can be used)
The above method is just an idea, I am open to ideas right now so please let me know what you think.
Also please do not bid if you have never done anything like this before (We require a professional to do this the first time round)
Also need an option to undo the data import if anything goes wrong as an alternate method to deleting products one by one.
We would also need this whole job to run as a crontask daily/weekly.
Currently we have the Total Import Pro which is time consuming and not a great module, if a freelancer could develop that more or create something better than that would be ideal
Additional Project Description:
02/05/2013 at 19:56 GMT
- 1st Script - To design and implement a better version of 'Total Import Pro'. The mapping of vendor feed into our website
2nd Job - To set up cronjob so that this is done if new product is added via vendor csv upload(first initial will be fetching all description and images for all products)
3rd - To run a script to see if any products have any errors or if any have UPC or manufacturer codes missing.
4th - To make sure all categories have all products in the correct place.
Vendor product ID | Manufacturer Part Number | Model Number | description | Manufacturer | Product | Group| Quantity_On_Hand Quantity_On_Order Due_Date price1 break1 price2 break2 price3 break3 price4 break4 price5 break5 weight EAN
Each product needs to be imported to a specified category.
Crontask will have to import all new products and place them into each specified category on a daily/weekly/monthly basis.
Please bare in mind all our vendors have different headings and each product HAS to be imported into the correct category, this can be done in any way. It should be included within the admin opencart.