Importing Data With Your Magento Listings

Laina M

May 10, 2022 18:50

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:

Importing From Magento if you Sell Configurable Products (Variations)
Information That Automatically Imports by Default
How to Import Additional Product Details
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.

How to Import Additional Product Details

Here's how you import attributes that are:

Not required within your Magento attribute sets.
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.

For more info about creating custom product attributes, please see Creating and Using Custom Product Attributes.

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