How can marketplace owners bulk curate products on a Vendo-powered marketplace?

Introduction

Vendo-powered marketplaces can easily onboard hundreds of sellers, allowing marketplace owners to create a remarkable offer for their customers. Quite often, though, the products that sellers sync from their existing Shopify, WooCommerce, or Magento stores need to be curated to be showcased on the Vendo-powered marketplace's storefront in a uniform way.

This article explains how Vendo marketplace owners can bulk curate their products on a Vendo-powered marketplace using the export and import of product catalog CSV files in the following steps:

Generating Products CSV export
Working with the export file
Importing curated products CSV file

Generate products CSV export.

There are two options for exporting product CSV files. Vendo marketplace owners can export all the products from the marketplace or only a selection of products. In both cases, the export functionality is available from the product listing page in the marketplace admin dashboard.

Here is a step-by-step guide on how to generate CSV products export.

Once the CSV product export is completed, the marketplace owner receives an email notification with the export file as an attachment.

Please Note! Depending on the number of products, it can take up to a few minutes.

Working with the product export file

Please note! Only attributes marked as editable (YES) are editable. Non-editable attributes are only for reference and to aid marketplace owners in the product curation process.

The CSV export file contains the following columns:

column	editable?	description
`product_id`	NO	Vendo internal Product ID to identify the product
`vendor_name`	NO	Product vendor name for easy filtering
`brand_name`	NO	Product brand name for easy filtering
`name`	YES	Product name
`description`	YES	Description downloaded from Shopify/Woo/Adobe: 1. `description` field uses HTML, and any HTML tag can be used. 2. When importing, Vendo removes any HTML tags and attributes beside tags as: `p` `ul` `li` `br` 3. `description` field is displayed on the Storefront under the `Details` dropdown on PDP
`meta_title`	YES	SEO product page title
`meta_description`	YES	SEO product page description
`meta_keywords`	YES	SEO product page keywords
`property1_name`	NO	Identifier of 1st product property, e.g., `material`
`property1_value`	YES	Value for `material`
`property2_name`	NO	2nd property. Which properties are included depends on the `Properties` priority. Priority is set on marketplace admin dashboard `/admin/properties` `Properties` can be re-arranged by drag and drop.
`property2_value`	YES
`property3_name`	NO
`property3_value`	YES
`property4_name`	NO
`property4_value`	YES
`tags`	YES	Product tags visible on PDP, e.g., `Vegan`
`labels`	YES	Product labels visible on PLP, e.g., `Featured`
`width`	YES
`height`	YES
`depth`	YES
`weight`	YES
`available_on`	YES	The start date is when the product should become visible on the marketplace's storefront. *If the product needs to be visible as soon as possible, please add a past date in the `available_on` field.
`discontinue_on`	YES	Date when the product should be taken off from the marketplace's storefront.
`status`	YES	Product status: 1. draft - not visible on the storefront 2. active - visible on the storefront 3. archived - hidden on the storefront *only products from approved vendors can have product status set to active.

Importing curated CSV product file

After editing the product fields in the CSV file, the marketplace owner can import the curated CSV file to the Vendo-powered marketplace.

Go to Products in the admin dashboard.
Click the Import button to open an upload popup.
Drag the curated import file to the designated area (a new popup will appear)
Click Continue button
Another page will appear:
Click Continue again
A confirmation screen appears:
It is possible to add some minor changes at this stage or click the Save and Finalize button, which will trigger the file processing.

Please Note: Processing a full import can take up to 20-30 minutes.

During processing, a screen displaying the import status is presented - this tab can be closed during the import process.

Once the product import process is complete, the marketplace owner receives an email confirmation with a link to the import report.

With functionalities such as bulk product curation, Vendo significantly reduces the time marketplace owners spend on marketplace product unification.

Please share your feedback.

We would love to hear your feedback at support@getvendo.com or through the chat available in the bottom right corner of your screen.