DDSDistributorseCommerceflexiPIMPIMUncategorized

Channelize Product Content From DDS to Your Ecommerce Touch-Points With flexiPIM

By November 17, 2020 January 11th, 2021 No Comments
DDS and flexiPIM connector

DDS (Distributor Data Solutions) is one of the leading product content providers. Products at DDS are viewed and advertised as planned by manufacturers, along with their corresponding features, specifications, installation videos, product brochures, enhanced images, spec sheets, and more.

Through offering strategic solutions to the complexities of e-commerce product content and data processing, DDS assists suppliers, distributors, and other industry professionals. Users will have a world-class e-commerce experience for customers by using cutting-edge data technologies to aggregate, refine, normalize, and deliver the best available product data.

In the Electrical, Lighting, Solar, Plumbing, HVAC, Tool, Protection, Utility, Datacom, Industrial Supply, Automation, and Industrial Gas + Welding industries, DDS partners with more than 400 suppliers (representing over 950 brands) as well as some of the top distributors and marketing groups.

flexiPIM – DDS Connector

The core purpose of flexiPIM is to maintain product content and act as a single repository to share product content wherever required. Mostly PIM users come with a requirement to fetch data from DDS and channelize it to their eCommerce touchpoints. This is why we, at flexiPIM, have developed the DDS-flexiPIM connector. In other words, flexiPIM acts as a bridge between DDS and the client’s eCommerce website. 

 

 

How Does DDS Provide Product Content?

DDS provides product content in an Excel sheet and JSON file. They put the file in an FTP or SFTP as requested by their client. We need to take data from FTP to sheets to use product content. The following are the data formats available in both Excel sheets and JSON.

Format of Excel Sheets

The following are the files available from DDS which contain different product content and each one is explained below.

Sheet Name Purpose
items.csv Master Sheet which contains master information about products like Manufacturer Catalog Number, UNSPSC, UPC, Long Description, Short Description, and so on 
specifications.csv Contains all attributes and is categorized into subgroups such as  Complementary, Offer Sustainability, Main, Environment, Contractual Warranty, and so on.
facet-keys.csv Contains facet attributes of the attributes
categories.csv Contains Product Category both manufacturer and client categorization
features.csv Contains Product Features
packaging.csv Contains Products packaging information like weight, UOM, and so on
alternate-images.csv Contains Alternate Image URLs of the Products
downloads.csv Contains Document URLs of the Products
videos.csv Contains Youtube URLs of the Products
image360.csv Contains iframe link to view 360-degree view of the Product

 

Format of JSON Sheets

Following are the formats of JSON which contain different product content as explained below

Key Purpose
product_id DDS Product’s Id
manufacturer_catalog_number Manufacturer Catalog Number of the Product
unspsc Product’s UNSPSC
name Name of the Product
manufacturer Manufacturer of the Product
short_description Short Description of the Product
long_description Long Description of the Product
region_id Product’s DDS Region Id
discount_code Product’s Discount Code
order_increment Product’s Order Increment
order_min Product’s Minimum Order Quantity
packages Product’s Package Information
price_effective_date Product’s Effective Date
standard_lead_time Product’s Standard Lead Time
product_life_cycle_status Product’s Life Cycle Status
units_qty UOM
primary_spec_sheet Primary Spec Sheet URL
features Product’s Features
specifications Product Specifications
downloads Product’s Documents Link
videos Product’s Youtube Video’s Link
categories Product’s Categories
facets Product’s Facets Attributes
image360 Contains iframe link to view 360-degree view of the Product
primary_image Product’s primary image
alternate_image Products Alternate image

 

How is Data from DDS Processed by flexiPIM Connector?

flexiPIM-DDS connector uses the JSON format to get product content from DDS. The client has to configure DDS FTP details on the connector’s configuration page. 

Field Purpose
Default PIM Channel flexiPIM channel to which you want to assign DDS products, categories, and attributes
FTP Address FTP address of the host in which DDS file is posted
FTP Username Username to access the FTP in which DDS file is posted
FTP Password The password of the username to access the FTP in which DDS file is posted
FTP Directory Directory Locations of the DDS file in FTP

 

On successful submission of the flexiPIM-DDS connector configuration form, You can run the manual sync by clicking on the “Sync Now” button on the flexiPIM-DDS connector’s sync page.

flexiPIM-DDS connector organizes DDS data into flexiPIM in the following ways,

DDS Fields Organized in flexiPIM
manufacturer_catalog_number Create an attribute in the name “Manufacture Catalog Number” and assign it to the “DDS General” attribute group
unspsc Create an attribute in the name “UNSPSC” and assign it to the “DDS General” attribute group
name Assign a value to the flexiPIM product name attribute
manufacturer Create an attribute in the name “Manufacturer” and assign it to the “DDS Manufacturer” attribute group
short_description Create an attribute in the name “Short Description” and assign it to the “DDS General” attribute group
long_description Assign a value to the flexiPIM product description attribute
packages Create an attribute group as “DDS Package” and assign attributes coming inside packages key to the above said attribute group
standard_lead_time Create an attribute in the name “Lead Time” and assign it to the “DDS General” attribute group
units_qty Create an attribute in the name “UOM” and assign it to the “DDS General” attribute group
primary_spec_sheet Create an attribute in the name “Primary Spec Sheet” and assign it to the “DDS Documents” attribute group
features Create an attribute in the name  “Features” and assign it to the “DDS General” attribute group
specifications Create an attribute in the name  “Specification” and assign it to the “DDS General” attribute group
downloads Create an attribute in the name  “Documents” and assign it to the “DDS Document” attribute group
videos Assign Video to the product
categories Create Categories and Assign them to respective Products
facets Create an attribute group as “DDS Facets” and assign attributes coming inside packages key to the above-said  attribute group
image360 Create an attribute in the name “Image 360” and assign it to the “DDS General” attribute group
primary_image Assign Image to the product
alternate_image Assign Image to the product

 

Once the sync is completed, all the products, categories, and attributes are created in flexiPIM as mentioned above. The sync is also auto-scheduled at the time of flexiPIM delivery as per clients’ requirements.

 

Below are a few examples of how DDS data is organized in flexiPIM.

DDS Specifications are organized in the following manner

DDS Specifications in flexiPIM

  1. DDS Facets are organized as seen below

DDS Facets in flexiPIM

  1. DDS Documents are organized as seen below

DDS documents in flexiPIM

  1. DDS Assets are organized as seen below

DDS assets in flexiPIM

DDS Assets in flexiPIM

 

After the first sync, the flexiPIM-DDS connector fetches only the new and updated products from DDS and updates them in flexiPIM. This is an additional feature provided by DDS to update just the new content.

This is how flexiPIM-DDS Connector syncs data from DDS to flexiPIM. Further,  Product content in flexiPIM updated by the flexiPIM-DDS Connector gets synced to the customer’s eCommerce site which the user can configure in flexiPIM.

 

MS Alavudeen

MS Alavudeen

Alavudeen comes with an experience of 3+ Years as a Software Engineer with a demonstrated history of working in the IT and services industry. He is skilled in Laravel, PHP, Python, Django, HTML, CSS, JavaScript, jQuery, AJAX, and Web Development.

Leave a Reply