Automatic Product Import / Deletion for my Magento Store using Magmi and Cron

Zrušen Zveřejněno Oct 17, 2015 K zaplacení v momentě doručení
Zrušen K zaplacení v momentě doručení

Attention: Magento, Magmi and Cron skills required.

I have a Magento store for which I update the product data using a csv provided by our wholesaler. Since the structure of the csv doesn’t match the Magento product attributes names I wrote a script in Excel that converts the csv into a new csv that matches the magento product attributes names. Then I import the data using Magmi. In addition I have to download the product images from my wholesaler and copy them into the corresponding folder as well.

To go a little more into details for the conversion process I have to do the following:

- Remove unused columns

- Change prices using a formula

- Change category name by combining category and sub category and for some adding an additional category on top

- Add some columns with standard values

- Duplicate image column

- Add names for picture in the media gallery based on images names

- Create a SKU from product and sub product number (since the sub product numbers don’t have a common denominator for grouping)

- Group items (to allow for size selection)

- Duplicate descriptions

- Rename the columns

- Eliminate or re-categorize any product that does not fit within my shops category structure

Reading through the Magmi setup choices it seems to me that all of that could be done by Magmi usining column mapper, SKU finder, default value setter, value replacer, grouped item processor, image attributes processor …

My wholesaler also provides me with a delete table. Again I convert the table and use Magmi to delete the data. The problem here is that the delete table, contrary to the product table only includes sub product numbers. So I have to reference to the product table to recreate my SKU, which is the product number and sub product number combined because of grouping.

What I’m looking for is someone who can configure my Magmi so I can use my wholesaler’s csv without any modifications. That goes for the product csv as well as the delete csv. In addition I believe it’s possible to have Magmi fetch the pictures for new products as well. Once all of that is working initiating the process manually I need a cron job that up that initiates that process once a day automatically so my shop stays up to date all the time without any manual intervention.

And most importantly - Do not destroy my shop in the process. Thanks

Magento PHP Softwarová architektura Webhosting Website Management

Identifikační číslo projektu: #8709595

O projektu

Projekt na dálku Aktivní Oct 17, 2015