This process needs to run automatically, but only when I initiate it.
The feed needs to update stock availability of items that are found in supplier XML feed into our existing DB
If a product is not in the XML feed but is in the DB, then it needs the product in the DB will be set to “inactive” not delete it, as it might be in pre-existing orders or might become available
Items only with bin location “PRE-XR” needs to be looked at in this API, items that have a different bin location are items stocked at our facility and that inventory is managed by the shopping cart already. (Currently only 100 items out of 2K products would be excluded).
If a product is in the XML feed but not in the DB then it needs to be added to inventory.
Retail price needs to be calculated based on the wholesale price.
New product ID # needs generated which is the linking ID between numerous tables.
Product images need to be imported from the XML image links (typically 1 image per product)
Main image is placed in the img folder and renamed as the product ID, then the store generates all the necessary thumbnails of that picture, perhaps after the image is added that store script can be activated to create those other images at that time.
Products need to be placed into existing categories only, based on their name (supplier has different categories that we don’t use)
Maybe several if – then statements based on predefined keywords, if this keyword is found place it in this category, etc. and if there’s no match then place it into a default category
If the product has attributes/options/variations such as size/color/type, those items need to be added under the primary product not as a separate product.
Site is PHP based (Prestashop) the database is (MySql - 150 Tables)
Expert in doing this sort of stuff... No upfront needed, all payments through Milestone Payment (Escrow).. Online 16 Hours a day, Can start right away.. Thanks