Solidus Import Products

This extension adds product import functionality to Solidus, with a bunch of features that give it similar functionality to Shopify's importer.

It's been built to be as simple as possible while still doing it's job, and almost the entire workflow of the script beyond creating products from a CSV file is configurable.

This extension adds a tab to the administration area of Solidus, allowing a logged-in user to select and upload a CSV file containing product information. The upload is then placed on queue for processing. Once it has been processed, the user who initiated the job is notified by email that their import has completed.

FEATURES

• A reasonably opinionated product import model should take the heavy lifting out of batch-importing products.
• Using things like class_eval, it can be extended or changed to do more, less, or something differently.
• Using ActiveJob, the import is no longer processed when the user uploads the CSV file (Note: this requires the proper installation and configuration of ActiveJob).
• Columns are mapped dynamically by default. This means that if you have a SKU column in your CSV file, it will be automatically set as the sku attribute of the Product model.
• Multiple taxonomies are supported (By default, the importer looks for Brand and Taxonomy). Multiple taxonomy nesting is also supported. (See the 'Taxonomies' area below)
• Multiple images are supported (By default, the importer looks for Image Main, Image 2, Image 3 and Image 4). Images can be loaded either from disk, or from a publicly-accessible URL.
• Automatically creating variants is supported out-of-the-box - the importer compares the imported data with already-created products (By default, on the Product's permalink attribute), and creates a variant of that product if it exists already. Custom fields are also supported if dynamic column mapping is enabled - simply having 'Color', 'Size', 'Material' columns in your CSV file for example, will automatically set the relevant custom fields on the variant to the values from the CSV.
• It now uses the Ruby 1.9.2 standard CSV library (a.k.a FasterCSV).

ActiveJob

This gem relies on ActiveJob. For more information see ActiveJob Rails Guide

TAXONOMIES

The columns of the CSV that contain taxonomies is configurable. Each of these columns can contain a number of formats that represent different hierarchies of taxonomies.

Examples

• Basic taxonomy association for Category: Furniture
• Multiple taxonomy association for Category: Furniture & Clearance
• Hierarchy taxonomy association for Category: Furniture > Dining Room > Tables
• Multiple hierarchy taxonomy association for Category: Furniture > Dining Room > Tables & Clearance > Hot this week

CONFIGURATION

All the configuration for this extension is inside the initializer generated when you run rake import_products:install. It's basically a big hash with manual column mappings (If you don't want to use dynamic column mapping), and a bunch of settings that control the workflow of the extension. Take a look at the initializer to see more details on each field.

In most cases, it's unlikely you will need to change defaults, but it's there is you need it.

TESTING

rake test_app
rake spec

INSTALLATION

1. Add the gem to your Gemfile, and run bundle install.    gem 'solidus_import_products', :git => 'git://github.com/2BeDigital/solidus_import_products.git' then bundle install

2. rails generate solidus_import_products:install

3. Configure the extension to suit your application by changing config variables in config/initializers/solidus_import_product_settings.rb

4. Run application!

SAMPLE FILEs

Some basic samples files could be find in spec/fixtures

ATTRIBUTION

The product import script was based on a simple import script written by Brian Quinn here. I've extended it quite a bit and tweaked it to fit my needs.

Copyright (c) 2010 Josh McArthur, released under the MIT License