Magento Extension Data Mapping to ReSci

At a high level, The Magento Extension queries data from certain tables in Magento, looks for particular data points and then generates bulk files that are then passed to ReSci to be ingested.

Below is the standard mapping for each data feed from Magento to ReSci. The value on the left of the => is the field from which we pull the data in Magento. The value on the right is the field in which this data lives in the ReSci database.

• Items
• Categories
• Users
• Orders
• Order items

Please review our Standard File Schema for more information and data definitions for each of these standard fields. (Magento => ReSci)

Items

• status and visibility => active
• product id => record_id
• name => name
• manufacturer => manufacturer
• sku => model
• stock quantity => quantity
• special_price and price => price
• gallery => image_list
• url => item_url
• parent product id => parent_record_id
• type_id => attribute_1
• category ids => categories

Categories

• category id => record_id
• name => name
• description => description
• parent category id => parent_record_id

Users

• customer_id => record_id
• email => email
• firstname, lastname, middlename, prefix, suffix => full_name
• default billing address street => address1
• default billing address city => city
• default billing address region name => state
• default billing address postcode => zip
• default billing address country code => country
• default billing address phone => phone
• date of birth => birthdate
• gender => gender
• created_at => account_created_on
• updated_at => last_log_on_at
• subscribed or not => subscriber_status

Orders

• order id => record_id
• customer id => user_record_id
• base subtotal => total_price
• base discount amount => discount_amount
• shipping amount => shipping_amount
• base tax amount => tax_amount
• order created_at => ordered_at
• payment method name => payment_method
• state => order_status

Order items

• order id => order_record_id
• product id => item_record_id
• product name => name
• quantity ordered => quantity
• price of 1 product => price
• price of 1 product x quantity ordered => final_price
• product sku => attribute_1
• product categories => categories

Have questions on any of the mapping above? Reach out to help@retentionscience.com and we will do our best to clarify further.