Importing Data With Your Magento Listings

This article explains what information imports from Magento into Solid Commerce.

It also explains how to set up Solid Commerce to maximize the data that imports with your Magento listings.

NOTE: We do not import products that have a status of disabled in Magento. If you would like to automatically import disabled products, you must change their status to enabled in Magento.

 

What we'll cover:

  1. Importing From Magento if you Sell Configurable Products (Variations)
  2. Information That Automatically Imports by Default
  3. How to Import Additional Product Details
  4. Related Articles

Importing From Magento if you Sell Variations

We can import configurable and bundle items (variations) from your Magento store. Only the child SKUs import, not the parent SKUs.

Magento's API does not support launching new variation-style listings through Solid Commerce. Instead, you can continue to create listings directly in Magento. The child SKUs will continue to import into Solid Commerce automatically so long as you leave the auto import turned on.

The price and quantity of the child items in your variation listings can be controlled by Solid Commerce.

Information That Automatically Imports by Default

If the products you are importing from Magento already exist in your Solid Commerce account, we will only import Marketplace Level information (such as the price) and product attributes that correspond to Magento attribute codes. Asterisks (*) in the tables below indicate fields that will still import from Magento even if a product already exists in Solid Commerce.

If a product doesn't already exist in Solid Commerce, we will import ALL of the fields in the tables below from Magento by default. You do not need to perform any additional setup to import this info.

In order to import these fields, we automatically create product attributes for any of the fields that do not already exist in your account.

 

Product Level Information

Solid Commerce Product Level Field
Magento Attribute Code
product custom sku sku
product name
name
manufacturer manufacturer
msrp msrp
product length

length

product height height
product weight weight
country of origin country/origin
upc upc
release date event_date_start
main image base image
thumbnail image small_image
alternate image1, alternate image2, etc {Any additional images}
model number model

*product attribute:Magento visibility

Here is what the numeric values that import into Solid Commerce represent:

1 - None
2 - Catalog
3 - Search
4 - Both Catalog and Search

visibility
 *product attribute:Magento Short Description short_description
 *product attribute:Magento categories names categories names
*product attribute:Magento attributes set name attribute set name
 *product attribute:Magento categories categories
 *product attribute:Tax_Class_Id Tax_Class_Id

 

 Inventory Level Information

Solid Commerce Inventory Level Field
Magento Attribute Code
cost cost
warehouse id sku

qty

NOTE: We will only import the quantity from Magento if the product doesn't exist in one of your Solid Commerce Warehouses yet.

inventory_level
storage location bin_picking_number

 

 Marketplace Level Information

Solid Commerce Marketplace Level Field
Magento Attribute Code
*mystore sale price exp price
*mystore on sale price expression special_price
*mystore sale start date special_from_date
*mystore sale end date special_to_date

*Gift Message (Visible in the Order Manager of Solid Commerce)

Order Gift Message

Order Item Gift Message

*mystore allow google checkout enable_googlecheckout
*Listing ID product_id

*mystore description

description

 

Additional Information We Automatically Import

  • If you have marked any Magento attributes are set as Yes under required, we will automatically create corresponding product attributes in Solid Commerce and import the data.

NOTE: We only attempt to import information from Magento once for each listing. If you later add attributes to your imported Magento listings directly in your Magento account, we will NOT import those additional attributes.

  • We can continually auto import new listings you create directly in your Magento store.
    • On the My Store tab, available through the Marketplaces menu -> Marketplaces Setup, keep the Automatically insert new products from your Magento store box enabled.

Importing_Data_From_Magento_auto_import_on.png

How to Import Additional Product Details

Here's how you import attributes that are:

  1. Not required within your Magento attribute sets.
  2. Not listed in the table in the previous section.

1) Create the attribute in Magento.

2) Create the corresponding custom product attribute in Solid Commerce.

  • Ensure that the name of the product attribute in Solid Commerce is identical to the attribute code in Magento.
  • All the custom product attributes you create will NOT have the "Magento" prefix.
    • This is different than the product attributes that we automatically create. Most of those have "Magento" as the prefix.
    • EXAMPLE: To import the created_at attribute from Magento, you would create a product attribute in Solid Commerce named created_at, not Magento created_at.

Importing_Data_From_Magento_created_at_attribute.png

 

3) Check the Automatically insert new products from your Magento store box in your My Store Marketplaces Setup.

Related Articles

 

Back to top

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

1 comment
  • What about when importing multiple categories for magento (i.e. two phone cases that fit 3 different phones). 

Please sign in to leave a comment.