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.

Example of a Shopify store populated using this feature: SwagPath.com

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.
    Sometimes Suppliers don't use Product Category in Product Data, so the autocomplete will not work, however you can still use keywords to filter the products if they happen to fill the Product Keyword Array field.
  • 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.
  • Import Tag: A name you will use to describe what you are exporter/importing.

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.

How to import your CSV into Shopify

Once you download the CSV from PSRESTful you can start the process to import it into your Shopify store.

Here are the steps to import your CSV(exported from PSRESTful) into Shopify:

  1. Go to your store admin page
  2. Click on Products menu
    shopify products
  3. Click on Import Button
    shopify import products by CSV
  4. Add your CSV file by clicking on Add file Button and selecting the file
    shopify import products by CSV Confirm and Preview
    If you already imported those products then you should click on the Overwrite checkbox, so the new data takes place.
  5. Click on Upload and preview Button and you should see a Preview similar to the following image
    shopify import products by CSV Preview example
  6. Once you click on Import Products Button, the process will start.
    You will receive a notification once the process is done.
Remember, you need to add metafields in your Shopify store to get maximum benefits from using our CSV Exporter.

The CSV does not include inventory information because we offer a separate format for that. If you prefer, you can update your inventory manually or create a script to automate frequent updates using your metafields for supplier, product ID, PartID, and our API.
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
<