CSV Exporter for Shopify, Magento & Custom Formats

Seamlessly Generate CSV Files for a Subset of Products

Our new CSV Exporter feature allows you to effortlessly generate CSV files tailored to the Magento, Shopify & Custom formats.
This powerful tool enables you to select a specific subset of products from your supplier's catalog and export the data with ease.

Start Now
csv exporter

Key Features:

  • Supplier Selection: Choose your desired supplier from the drop-down menu to filter products.
  • Environment Setting: Switch between different environments (PROD, STAGING) for accurate data extraction.
  • Format Options: Currently supporting the Magento, Shopify Product, Shopify Inventory, and Shopify MinMaxfy formats, with more formats to be added soon.
  • Store Name: Input store name to customize the CSV output(tier_prices or vendor id productBrand is not available).
  • Currency Selection: Select the currency in which the product prices will be displayed.
  • Price Type: Choose between different price types such as Net or List.
  • Configuration Type: Specify the configuration type, like Decorated or Blank.
  • Category Filter: Narrow down the product list by selecting specific categories.
    Not needed when you know exactly what products IDs you want to export.
  • Product IDs: Directly input product IDs to generate a precise subset of products.
    It can be a comma separated list of product IDs or even with line breaks.
    Useful when copying & pasting from supplier's bestsellers spreadsheets.
  • Product Limitation: Define the maximum number of products to be analyzed.

Powered by Latest Standards:

This feature leverages the latest Product Data version 2.0.0 and Media Content version 1.1.0, ensuring you get the most accurate and up-to-date information in your CSV exports.

Examples:

Supplier Environment Category Format Link
Ariel Premium Supply PROD Drinkware Magento Download
Hit Promotional Products PROD Few selected products Shopify Product Download
Hit Promotional Products PROD Few selected products Shopify Inventory Download
Ariel Premium Supply PROD Few selected products Shopify MinMaxfy Download

Information per Format

The Magento format is a CSV file that contains the following columns:

  • sku
  • name
  • description
  • short_description
  • product_type
  • categories
  • attribute_set_code
  • color
  • size
  • source
  • brand
  • price
  • visibility
  • min_cart_qty
  • capacity
  • production_time
  • base_image
  • small_image
  • thumbnail
  • tier_prices
  • configurable_variations
  • configurable_variation_labels
  • status
  • _store
  • website_id
  • manage_stock
  • is_in_stock
  • product_websites
  • keywords
  • imprint_size
  • primary_material
  • is_rush_service
  • gtin
  • dimension_uom
  • depth
  • height
  • width
  • weight

The Shopify Product format is a CSV file useful for importing & updating your products on Shopify store.
It will contain the following columns:

  • Handle
  • Title
  • Body (HTML)
  • Vendor
  • Type
  • Tags
  • Published
  • Option1 Name
  • Option1 Value
  • Option2 Name
  • Option2 Value
  • Variant SKU
  • Variant Grams
  • Variant Fulfillment Service
  • Variant Price
  • Variant Image
  • Variant Requires Shipping
  • Variant Taxable
  • Image Src
  • Image Position
  • Image Alt Text
  • Gift Card
  • SEO Title
  • SEO Description
Some Meta fields like for product:
  • product.metafields.psrestful.price_expires_date
  • product.metafields.psrestful.brand
  • product.metafields.psrestful.is_caution
  • product.metafields.psrestful.caution_comment
  • product.metafields.psrestful.line_name
  • product.metafields.psrestful.unspsc_commodity_code
  • product.metafields.psrestful.imprint_size
  • product.metafields.shopify.default_setup_charge
  • product.metafields.shopify.default_run_charge
And Some Meta fields like for product:
  • variant.metafields.psrestful.variant_primary_material
  • variant.metafields.psrestful.variant_is_rush_service
  • variant.metafields.psrestful.variant_lead_time
  • variant.metafields.psrestful.variant_is_caution
  • variant.metafields.psrestful.variant_caution_comment
  • variant.metafields.psrestful.variant_is_on_demand
  • variant.metafields.psrestful.variant_is_hazmat
  • variant.metafields.psrestful.variant_shape
  • variant.metafields.psrestful.variant_unspsc
  • variant.metafields.psrestful.variant_nmfc_code
  • variant.metafields.psrestful.variant_nmfc_description
  • variant.metafields.psrestful.variant_nmfc_number
  • variant.metafields.psrestful.variant_country_of_origin
  • variant.metafields.psrestful.variant_gtin
  • variant.metafields.psrestful.variant_dimension_unit
  • variant.metafields.psrestful.variant_dimension_depth
  • variant.metafields.psrestful.variant_dimension_height
  • variant.metafields.psrestful.variant_dimension_width

Shopify Inventory format

The Shopify Inventory format is a CSV file for updating your inventory on Shopify store.
It will contain the following columns:

  • Handle
  • Title
  • Option1 Name
  • Option1 Value
  • Option2 Name
  • Option2 Value
  • Option3 Name
  • Option3 Value
  • SKU
  • Incoming
  • Available
  • On hand
  • Unavailable
  • Shop location

The Shopify MinMaxfy format is a CSV file that contains the following columns:

  • Handle
  • Title
  • Min
  • Max
  • Multiple

It is a CSV for the MinMaxfy App used to set the minimum and maximum quantities for a product. The Multiple column is used to set the quantity increment. So we defaulted to 1.

Here is their documentation for the file.

If your store is using a custom e-commerce platform, or any other e-commerce that is not supported at the moment, you can reach out, and we will generate a custom exporter for you for a small fee.

This custom exporter will be tailored to your e-commerce platform, will contain the columns you need, and will be only available to your account.

Please, contact us if you want to know more about the feature or if you want to add your e-commerce CSV format to the Exporter