{"id":923,"date":"2020-10-24T12:27:47","date_gmt":"2020-10-24T19:27:47","guid":{"rendered":"https:\/\/wpdatasync.com\/?post_type=wp_data_sync_doc&p=923"},"modified":"2021-12-04T19:52:58","modified_gmt":"2021-12-05T02:52:58","slug":"data-source-mapping","status":"publish","type":"wp_data_sync_doc","link":"https:\/\/wpdatasync.com\/documentation\/data-source-mapping\/","title":{"rendered":"Data Source Mapping"},"content":{"rendered":"\n

Prerequisites: Source Keys<\/a><\/p>\n\n\n\n

Data source mapping is the process of relating the data fields from your data source with the data fields WordPress or WooCommerce use for your remote website.<\/p>\n\n\n\n

Note:<\/strong> We recommend obtaining your Remote Keys<\/a> before you begin mapping your data source.<\/p>\n\n\n\n

Example Data Source Request – Response<\/h2>\n\n\n\n

This array can be found in the response of your Request Tes<\/a>t. We use this example array for all examples below.<\/p>\n\n\n

\narray(\n    details => array(\n        name => 'Awesome Sleeper Sofa',\n        desc => 'This is the best sleeper sofa ever.',\n    ),\n    tags     => 'Sofa,Living Room,Sleeper',\n    brand    => 'Ashley',\n    sku      => 'SF3316',\n    imageset => array(\n        0 => 'image-1.jpg',\n        1 => 'image-2.jpg'\n    ),\n    thumb => 'https:\/\/some-website.com\/images\/thumb.jpg'\n);\n<\/pre><\/div>\n\n\n
Post Data or WooCommerce Product Data<\/h2>\n\n\n\n
Data stored in the wp_posts<\/code> table.<\/p>\n\n\n\n
\"ata<\/figure>\n\n\n\n
Post Meta or WooCommerce Product Meta<\/h2>\n\n\n\n
Data stored in the wp_postmeta<\/code> table.<\/p>\n\n\n\n
\"WP<\/figure>\n\n\n\n
Post Thumbnail or WooCommerce Product Image<\/h2>\n\n\n\n
Featured image for any post_type<\/code>.<\/p>\n\n\n\n
\"WP<\/figure>\n\n\n\n
Taxonomies or WooCommerce Product Taxonomies<\/h2>\n\n\n\n
Data stored in the wp_taxonomy<\/code> and wp_terms<\/code> tables.<\/p>\n\n\n\n
Note:<\/strong> tags<\/code> is comma separated string Sofa,Living Room,Sleeper<\/code> will create 3 terms.<\/p>\n\n\n\n
  1. Sofa<\/li>
  2. Living Room<\/li>
  3. Sleeper<\/li><\/ol>\n\n\n\n
    \"WP<\/figure>\n\n\n\n
    WooCommerce Product Gallery<\/h2>\n\n\n\n
    Data stored in the wp_postmeta<\/code> table.<\/p>\n\n\n\n
    Note:<\/strong> imageset<\/code> will produce 2 images. The Prefix URL will be applied to both image names.<\/p>\n\n\n\n