Import/Export Module/Extension with Custom Options, Tier Prices and Grouped Products

Tier Pricing now works with customer groups and if you use the AdjustWare Percent Tier Pricing Module you can now do percents.

Everyone wants to import and export with custom options and we don't know why it wasn't already made.

We've done it and it works.

You can import and export custom options (with limitations), tier prices and grouped products.

Use this to import your products in a CSV format..

Please note that this extension is provided as is. It is recommended to always backup your installation prior to usage.

Documentation:

• Extract the files from the .zip file
• Upload them to your server
• Done

Download the custom-import.csv, this file shows you the basic usage of the columns. New column names are custom_options, tier_prices and grouped_products

Usage:

Example custom options: Second option:drop_down:0:1##3:fixed:0.0000:sku-42|1:fixed:0.0000:sku-43|4:fixed:0.0000:sku-45|2:fixed:0.0000:@@johns option:radio:0:2##1:fixed:2.00:|2:fixed:4.00 Explination: option name:option type:required:order##value name:price type:price:sku|value name 2:price type:price:sku@@option name 2:option type:required:order##value name:price type:price:sku|value name 2:price type:price:sku

Example tier prices: 50=17.85|120=16.95 Explination: quantity=price|quantity2=price2

If you are using customer groups such as wholesaler etc.. then you would use this: qty=price:customer_group#|qty2=price:customer_group#

If you are using the AdjustWare Percent Tier Pricing Module you can do this: qty=percent|qty=percent2, 50=5%|100=8%

Example grouped products: SG1|SG2 Explination: associated product sku 1|associated product sku 2 Explination: sku of first associated product|sku of second associated product HINT: all associated products must be in rows above the grouped product so that if they are not in the system, they will get created first, then the sku's will be valid for the grouped product.

Category Import/Export Module/Extension

REQUIREMENTS: Magento 1.3.x

PATCH FOR MAGENTO 1.2.x: SEE BELOW

DESCRIPTION:

This module allows you to import and export your categories with hierarchy. See example categories.csv file to view an example. The importer uses a faux_id column for creating new categories.

INSTALLATION INSTRUCTIONS:

1. Unzip the file

2. Back up your magento files. This is a precaution.

3. Upload the app folder to your magento directory and allow it to overwrite if needed, it should just ask for overwriting a directory, which is just adding the new app/etc/modules/JC_All.xml file and then adding the new JC folder to the app/code/local/ folder.

4. Go to your magento admin and go to System->Import/Export->Advanced Profiles

5. Add a new Profile and name it Category Import

6. Open the import_actions.xml file that you recieved with the module and copy/paste it into the new advanced profile

7. Save. You now have the ability to import categories.

8. Repeat steps 5-7 for category export, name the new profile Category Export and copy/paste the export_actions.xml file to it and save the profile.

9. Modify the categories.csv and upload it to your var/import folder. This is the file that contains your categories to import.

10. Your exported categories will be exported to the var/export folder as export_cats.csv

11. Enjoy.

Import Usage: See the categories.csv for example import usage. If you are creating new categories, make your default category in the admin area and then get the id for creating the new categories. When creating a new category, say you have the default category with a sub category of cat 1 and that has a sub of sub cat 2

EXAMPLE:
Default Category
------Cat 1
------------Sub Cat 2

your import would need to use the Default Category id for the parent_id of Cat 1 then you would take and put a number in the faux_id field for Cat 1 of say 100, then in the parent_id of the Sub Cat 2 field put f-100 in the field, this references the faux_id of the Cat 1 category and tells the importer that Cat 1 is the parent of Sub Cat 2.

HINTS: If you are just re-ordering categories you do not need to use the faux_id column, you only need to use faux_id field if the category that will be a parent is a new category. Every new category has to have a faux_id otherwise you cannot use it as a parent in a new import. When using the faux_id # as a parent_id you must have the f- in front of the

number example: f-100.

PATCH FOR MAGENTO 1.2.x:

For some reason when I tried to use this on a Magento 1.2.x version, the export broke, so there is a file in the app/code/local/JC/Catalog/Model/Convert/Adapter folder called Category_mag_1.2.1.php.

If you need to run this module on 1.2.x then you need to rename the original Category.php file to Category_orig.php and then rename the Category_mag_1.2.1.php to Category.php and you should be running just fine.