Skip to main content
User Guides

Manage Products with Files

In this guide, you’ll learn how to bulk import new products, update existing products and delete products using files.

Overview​

Products are the primary catalog entity, and the primary function of the marketplace platform is to sell products on the storefronts. Products can be uploaded using files.

CSV files​

CSV files are supported for importing products due to their wide usage and convenience, as they can be read by almost any text editor or spreadsheet package, and do not contain any code.

JSON Lines (JSONL) files​

JSONL files are supported for importing products as they handle tabular data cleanly and without any ambiguity. They are particularly useful for ingesting larger datasets as the data can be streamed rather than fully loaded into memory. Each line of the JSONL file should be a JSON object, representing a product, in this case, held within a pair of curly brackets. The following example contains three products:

product.jsonl
{"type": "complex", "name": "GFP ELISA Kit, Cell Biolabs", "brand": "Cell Biolabs", "prices": [{"price": "775.38", "country": "GB", "currency": "USD"}], "unit_size": "Each", "categories": ["Home", "Assays", "ELISAs"], "image_urls": ["https://us.vwr.com/stibo/bigweb/std.lang.all/72/62/17627262.jpg"], "product_identifier": "caueuqlvbzjnfknu", "properties": {"Sensitivity": "30 pg/mL", "Detection Method": "Colorimetric", "Storage Temperature": "4°C and –80°C", "Description": "GFP ELISA Kit", "Size": "96 Assays"}, "description": "<div class=\"textBodyText expander\" data-linkify=\"this\" data-linkify-target=\"_self\">\n<div class=\"textBodyText\">\nCell Biolabs’ GFP ELISA Kit is an enzyme immunoassay developed for detection and quantitation of GFP or GFP fusion protein in cell or tissue samples<br>\n</div>\n<br>\n<div class=\"textBodyText\">\nThe quantity of GFP or its variants (including BFP, CFP and YFP) in an unknown sample is determined by comparing its absorbance with that of a known recombinant GFP standard curve. The kit has detection sensitivity limit of 30 pg/mL GFP.<br>\n</div>\n</div>", "manufacturer": "Cell Biolabs", "document_urls": null, "product_page_url": "https://us.vwr.com/store/product/18011707/gfp-elisa-kit-cell-biolabs", "variants": [{"sku": "102963-622EA", "name": "GFP ELISA Kit, Cell Biolabs", "brand": "Cell Biolabs", "codes": [{"type": "EAN", "code": "vftpmvqktezavpml"}, {"type": "MPN", "code": "AKR-121"}, {"type": "UNSPSC", "code": "kissqvheabnjtqfl", "version": "17"}], "prices": [{"price": "775.38", "country": "GB", "currency": "USD"}], "unit_size": "Each", "unit_label": "EA", "options": [{"name": "size", "value": "Each"}], "image_urls": ["https://us.vwr.com/stibo/bigweb/std.lang.all/72/62/17627262.jpg"], "variant_identifier": "bahskfbjcvwpywck", "description": "<div class=\"textBodyText expander\" data-linkify=\"this\" data-linkify-target=\"_self\">\n<div class=\"textBodyText\">\nCell Biolabs’ GFP ELISA Kit is an enzyme immunoassay developed for detection and quantitation of GFP or GFP fusion protein in cell or tissue samples<br>\n</div>\n<br>\n<div class=\"textBodyText\">\nThe quantity of GFP or its variants (including BFP, CFP and YFP) in an unknown sample is determined by comparing its absorbance with that of a known recombinant GFP standard curve. The kit has detection sensitivity limit of 30 pg/mL GFP.<br>\n</div>\n</div>", "manufacturer": "Cell Biolabs", "document_urls": null, "product_page_url": "https://us.vwr.com/store/product/13411864/beeblottm-nbsp-automated-immunoblot-processor-gold-standard-diagnostic"}]}
{"type": "complex", "name": "EnzyChrom™ Neuraminidase Assay Kit, BioAssay Systems", "brand": "BioAssay Systems", "prices": [{"price": "620.02", "country": "GB", "currency": "USD"}], "unit_size": "Each", "categories": ["Home", "Assays", "Enzyme Assays"], "image_urls": ["https://us.vwr.com/stibo/bigweb/std.lang.all/60/95/21276095.jpg", "https://us.vwr.com/stibo/bigweb/std.lang.all/59/21/21275921.jpg", "https://us.vwr.com/stibo/bigweb/std.lang.all/60/96/21276096.jpg"], "product_identifier": "yavggimyypeidoeg", "properties": {"Method": "OD570 nm, or FL530/585 nm", "Processing Time": "60 minutes", "Sample": "Biological", "Description": "Neuraminidase Assay Kit", "Size": "100 assays"}, "description": "<div class=\"textBodyText expander\" data-linkify=\"this\" data-linkify-target=\"_self\">\n<div class=\"textBodyText\">\nFor quantitative determination of neuraminidase activity and screen for neuraminidase inhibitor.<br>\n</div>\n<br>\n<div class=\"textBulletPoint\">\n\n<div class=\"textBulletPoint\">\n<ul>\n<li>Linear detection range 0.1 to 10 U/L for colorimetric assays and 0.01 to 2 U/L for fluorimetric assays</li>\n<li>Can be readily automated to test thousands of samples per day</li>\n</ul>\n</div>\n</div>\n<br>\n<div class=\"textBodyText\">\nNeurominidase (also known as Sialidase) is an enzyme that hydrolyzes terminal sialic acid residues on poly-saccharide chains<br>\n</div>\n<br>\n<div class=\"textBodyText\">\nBioAssay Systems’ neuraminidase assay measures the sialic acid released by neuraminidase in one step. The change in color intensity of the reaction product at 570nm or fluorescence intensity at λex/em = 530/585nm is directly proportional to neuraminidase activity in the sample.<br>\n</div>\n<br>\n<div class=\"textBodyText\">\nIt is predominantly expressed in microorganisms such as bacteria and viruses. Cleavage of sialic acid residues by neuraminidase is believed to play several roles in infection by influenza viruses. It is thought to assist in the penetration of mucosal linings, the invasion of target cells, the elution of progeny viruses from infected cells, and the prevention of self-aggregation. Thus, neuraminidase is an important target for influenza drug development and simple, direct and automation-ready. Procedures for measuring neuraminidase activity find wide applications in research and drug discovery.<br>\n</div>\n</div>", "manufacturer": "BioAssay Systems", "document_urls": null, "product_page_url": "https://us.vwr.com/store/product/21315041/enzychromtm-neuraminidase-assay-kit-bioassay-systems", "variants": [{"sku": "75878-152EA", "name": "EnzyChrom™ Neuraminidase Assay Kit, BioAssay Systems", "brand": "BioAssay Systems", "codes": [{"type": "EAN", "code": "jehrqkxbpwkljewb"}, {"type": "MPN", "code": "ENEU-100"}, {"type": "UNSPSC", "code": "mpngijbjpnlqaofb", "version": "17"}], "prices": [{"price": "620.02", "country": "GB", "currency": "USD"}], "unit_size": "Each", "unit_label": "EA", "options": [{"name": "size", "value": "Each"}], "image_urls": ["https://us.vwr.com/stibo/bigweb/std.lang.all/60/95/21276095.jpg", "https://us.vwr.com/stibo/bigweb/std.lang.all/59/21/21275921.jpg", "https://us.vwr.com/stibo/bigweb/std.lang.all/60/96/21276096.jpg"], "variant_identifier": "luzbngzhblbmqfgw", "description": "<div class=\"textBodyText expander\" data-linkify=\"this\" data-linkify-target=\"_self\">\n<div class=\"textBodyText\">\nFor quantitative determination of neuraminidase activity and screen for neuraminidase inhibitor.<br>\n</div>\n<br>\n<div class=\"textBulletPoint\">\n\n<div class=\"textBulletPoint\">\n<ul>\n<li>Linear detection range 0.1 to 10 U/L for colorimetric assays and 0.01 to 2 U/L for fluorimetric assays</li>\n<li>Can be readily automated to test thousands of samples per day</li>\n</ul>\n</div>\n</div>\n<br>\n<div class=\"textBodyText\">\nNeurominidase (also known as Sialidase) is an enzyme that hydrolyzes terminal sialic acid residues on poly-saccharide chains<br>\n</div>\n<br>\n<div class=\"textBodyText\">\nBioAssay Systems’ neuraminidase assay measures the sialic acid released by neuraminidase in one step. The change in color intensity of the reaction product at 570nm or fluorescence intensity at λex/em = 530/585nm is directly proportional to neuraminidase activity in the sample.<br>\n</div>\n<br>\n<div class=\"textBodyText\">\nIt is predominantly expressed in microorganisms such as bacteria and viruses. Cleavage of sialic acid residues by neuraminidase is believed to play several roles in infection by influenza viruses. It is thought to assist in the penetration of mucosal linings, the invasion of target cells, the elution of progeny viruses from infected cells, and the prevention of self-aggregation. Thus, neuraminidase is an important target for influenza drug development and simple, direct and automation-ready. Procedures for measuring neuraminidase activity find wide applications in research and drug discovery.<br>\n</div>\n</div>", "manufacturer": "BioAssay Systems", "document_urls": null, "product_page_url": "https://us.vwr.com/store/product/13411864/beeblottm-nbsp-automated-immunoblot-processor-gold-standard-diagnostic"}]}
{"type": "complex", "name": "GLP-1 Total ELISA Assay Kit, Eagle Biosciences, Inc.", "brand": "Eagle Biosciences", "prices": [{"price": "850.00", "country": "GB", "currency": "USD"}], "unit_size": "Each", "categories": ["Home", "Assays", "ELISAs"], "image_urls": [], "product_identifier": "pslnzcuavddwgvci", "properties": {"Conjugate ELISA": "HRP", "Description": "GLP-1 Total ELISA Assay Kit", "Size": "1 kit"}, "description": "<div class=\"textBodyText expander\" data-linkify=\"this\" data-linkify-target=\"_self\">\n<div class=\"textBodyText\">\nGLP-1 Total ELISA determines sum of glucagon-like peptide-1 (7-36) &amp; (9-36) in plasma.<br>\n</div>\n<br>\n<div class=\"textBulletPoint\">\n\n<div class=\"textBulletPoint\">\n<ul>\n<li>Dynamic Range: 2 -54 pmol/L</li>\n<li>Sensitivity: 0.6 pmol/L</li>\n<li>Incubation: overnight</li>\n</ul>\n</div>\n</div>\n<br>\n<div class=\"textBodyText\">\nThe primary amino acid sequence of GLP-1 peptide is identical among mammalian species, i.e. rat, mouse, pig, human, etc. The Eagle Biosciences GLP-1 Total ELISA Assay Kit (enzyme-linked immunoassay kit) is intended quantitative determination of sum value of glucagon-like peptide-1 (7-36) and (9-36) [GLP-1 (7-36)] and (9-36) [GLP-1 (9-36)] in plasma samples. Eagle Biosciences GLP-1 Total ELISA Assay Kit is for research use only and not to be used in diagnostic procedures.<br>\n</div>\n</div>", "manufacturer": "Eagle Biosciences", "document_urls": null, "product_page_url": "https://us.vwr.com/store/product/23210180/glp-1-total-elisa-assay-kit-eagle-biosciences-inc", "variants": [{"sku": "102994-424EA", "name": "GLP-1 Total ELISA Assay Kit, Eagle Biosciences, Inc.", "brand": "Eagle Biosciences", "codes": [{"type": "EAN", "code": "ygglkpyccdkjhfih"}, {"type": "MPN", "code": "GP131-K01"}, {"type": "UNSPSC", "code": "myfchiwrywkisfif", "version": "17"}], "prices": [{"price": "850.00", "country": "GB", "currency": "USD"}], "unit_size": "Each", "unit_label": "EA", "options": [{"name": "size", "value": "Each"}], "image_urls": [], "variant_identifier": "qmycncdmeoanscho", "description": "<div class=\"textBodyText expander\" data-linkify=\"this\" data-linkify-target=\"_self\">\n<div class=\"textBodyText\">\nGLP-1 Total ELISA determines sum of glucagon-like peptide-1 (7-36) &amp; (9-36) in plasma.<br>\n</div>\n<br>\n<div class=\"textBulletPoint\">\n\n<div class=\"textBulletPoint\">\n<ul>\n<li>Dynamic Range: 2 -54 pmol/L</li>\n<li>Sensitivity: 0.6 pmol/L</li>\n<li>Incubation: overnight</li>\n</ul>\n</div>\n</div>\n<br>\n<div class=\"textBodyText\">\nThe primary amino acid sequence of GLP-1 peptide is identical among mammalian species, i.e. rat, mouse, pig, human, etc. The Eagle Biosciences GLP-1 Total ELISA Assay Kit (enzyme-linked immunoassay kit) is intended quantitative determination of sum value of glucagon-like peptide-1 (7-36) and (9-36) [GLP-1 (7-36)] and (9-36) [GLP-1 (9-36)] in plasma samples. Eagle Biosciences GLP-1 Total ELISA Assay Kit is for research use only and not to be used in diagnostic procedures.<br>\n</div>\n</div>", "manufacturer": "Eagle Biosciences", "document_urls": null, "product_page_url": "https://us.vwr.com/store/product/13411864/beeblottm-nbsp-automated-immunoblot-processor-gold-standard-diagnostic"}]}

Further JSONL file explanations can be found here.

Creating products with a file​

Simple products do not have variants and complex products have variants. CSV files only support the creation of simple products. However, it is possible to create simple and complex products by uploading a JSONL file. Products must include all the required fields. Each line of the JSONL file should contain the data required for a simple or complex product. The example below contains a complex product with a variant:

DANGER

As each product is a large, nested structure, they can be formatted to aid with viewing by adding indentations and aligning braces, as shown below, but cannot be imported in this form. Each product must be held on a single line as per the previous example.

imported-product.json
{
    "name": "BeeBlot™ Automated Immunoblot Processor, Gold Standard Diagnostic",
    "sku": "1234",
    "type": "complex",
    "brand": "brand name",
    "manufacturer": "manufacturer name",
    "codes": [
        {
            "code": "13411862134",
            "type": "MPN"
        }
    ],
    "prices": [
        {
            "price": "38467.37",
            "country": "GB",
            "currency": "GBP"
        }
    ],
    "categories": [
        "Home",
        "Blotting Apparatus"
    ],
    "image_urls": [
        "https://us.vwr.com/stibo/bigweb/std.lang.all/13/56/13411356.jpg",
        "https://us.vwr.com/stibo/bigweb/std.lang.all/13/57/13411357.jpg",
        "https://us.vwr.com/stibo/bigweb/std.lang.all/13/58/13411358.jpg",
        "https://us.vwr.com/stibo/bigweb/std.lang.all/13/59/13411359.jpg",
        "https://us.vwr.com/stibo/bigweb/std.lang.all/13/60/13411360.jpg",
        "https://us.vwr.com/stibo/bigweb/std.lang.all/13/61/13411361.jpg"
    ],
    "product_identifier": "nzpkuuirhtia",
    "properties": {
        "Capacity": "50 strips per Run",
        "quantity": "1 x each",
        "Dimensions": "64 x 62 x 45 cm",
        "Description": "BeeBlotTM Immunoblot Processor",
        "Power supply": "100-240V, 50-60HZ",
        "Ordering information:": "GSD experts will fully install, set up and train according to your specific laboratory requirements."
    },
    "description": "<div class=\"textBodyText expander\" data-linkify=\"this\" data-linkify-target=\"_self\">\n<div class=\"textBodyText\">\nIncrease productivity while reducing errors with automated processing, reading and analysis for strip based assays<br>\n</div>\n<br>\n<div class=\"textBodyText\">\nThe BeeBlot™ semi-automated immunoblot processor automates the protocol for most strip based assays, including Line Immunoassays and traditional Western Blots. When combined with the BLOTrix scanner and analysis software, processing and software-assisted interpretation of immunoblot diagnostic assays is possible.<br>\n</div>\n<br>\n<div class=\"textBodyText\">\nThe BLOTrix Scanner captures digital imagery of developed immunoassay strips. Simply load the tray from the BeeBlot processor into the reader, and the fully-integrated software assists with band identification and band interpretation. Images and results can be archived, and automatically sent to the LIS/LIMS system.<br>\n</div>\n<br>\n<div class=\"textBodyText\">\nGold Standard Diagnostics provides the instrumentation and software required to automate the labor-intensive manual processing of immunoblot assays.<br>\n</div>\n<br>\n<div class=\"textOrdering\">\n<b>Ordering information: </b>GSD experts will fully install, set up and train according to your specific laboratory requirements.<br>\n</div>\n</div>",
    "document_urls": null,
    "product_page_url": "https://us.vwr.com/store/product/13411864/beeblottm-nbsp-automated-immunoblot-processor-gold-standard-diagnostic",
    "variants": [{"name": "BeeBlot™ Automated Immunoblot Processor, Gold Standard Diagnostic",
                "sku": "123-1",
                "unit_size": "1 x each",
                "unit_label": "EA",
                "codes": [
                    {
                        "code": "13411862134-1",
                        "type": "MPN"
                    }
                ],
                "prices": [
                    {
                        "price": "38467.37",
                        "country": "GB",
                        "currency": "GBP"
                    }
                ],
                "quantity": "1 x each",
                "options": [{"name": "option_name", "value": "option_value"}],
                "categories": [
                    "Home",
                    "Blotting Apparatus"
                ],
                "image_urls": [
                    "https://us.vwr.com/stibo/bigweb/std.lang.all/13/56/13411356.jpg",
                    "https://us.vwr.com/stibo/bigweb/std.lang.all/13/57/13411357.jpg",
                    "https://us.vwr.com/stibo/bigweb/std.lang.all/13/58/13411358.jpg",
                    "https://us.vwr.com/stibo/bigweb/std.lang.all/13/59/13411359.jpg",
                    "https://us.vwr.com/stibo/bigweb/std.lang.all/13/60/13411360.jpg",
                    "https://us.vwr.com/stibo/bigweb/std.lang.all/13/61/13411361.jpg"
                ],
                "variant_identifier": "nzpkuuirhtia-1",
                "document_urls": null,
                "product_page_url": "https://us.vwr.com/store/product/13411864/beeblottm-nbsp-automated-immunoblot-processor-gold-standard-diagnostic"}]
}

Uploading CSV Files​

CSV files can be used to create, update, archive and delete products.

To import products as a CSV, ensure your data is formatted in a comma-delimited CSV file. Sample templates can be accessed during the import process.

To perform a bulk product update, ensure that you include the existing Product Identifier in your CSV file and update the corresponding product values as needed. It's important to note that you don't need a different template for bulk updates, you can simply re-use the same CSV file when importing new products into Axiom.

Creating and Updating Products​

To begin uploading a CSV file, head over to the Products page or the File Imports page within the Products area of the platform. Click Import, then select Products CSV file.

Data Import​

A template is available for download by clicking the Products icon: this includes the fields required by Axiom. The required fields are also highlighted on the right side of the page along with other supported fields.

You can also use a file with your own field names which can then be mapped to Axiom fields later in the import process.

Once you have your CSV file ready for import, drag & drop or click Click to Browse to select the file. To upload, click Continue on the top-right of the page.

Field Mapping​

The field mapping step allows you to select which fields from your CSV match the corresponding Axiom fields. At least all of the required Axiom fields must be used before the import can proceed.

Upon beginning this step, the dropdowns will automatically try to select the appropriate Axiom fields based on the naming of your fields. If any of these are incorrect, please adjust as required. If you are using one of the templates, these will automatically map across correctly.

When working with a field/dropdown, a data preview for that field can be viewed on the right hand side.

Data Preview​

After mapping your desired fields (being sure to include all Axiom required fields), click continue to proceed to the review step. A preview of the data will be shown in a table.

Once satisfied, click Continue to begin importing the products from your CSV file.

Post-import​

You will recieve a notification both in the platform (found under the activity section of the analytics page) and via email once your import has completed, notifying you of any errors with your product data. The notification will include the count of successfully imported products, the number of errors encountered, as well as a link to the error file. If you require further assistance, feel free to forward the error file to support@axiomdata.io.

All past and current imports can be viewed on the Imports page. To view more detail about an import, click on the table row.

On the import details page, any errors can be viewed in the errors table, including file rows and error messages. The original CSV file can be downloaded through the Download File button under ....

Additionally, you can download a copy of your original file with an additional errors column to help identify which rows need adjusting. To do this, click the Download Errors button.

Required fields for a CSV import​

The required fields can be found highlighted in green in the template here.

FieldDescription
Language CodeA code used to identify the language that the product information is being provided in, e.g., en for English.
Product IdentifierA unique identifier that is used to clearly identify the product being sold.
NameThe name field is a string with a recommended limit of 1-150 characters, and it can contain Unicode characters (recommended: ASCII only).
SKUAbbrev. for Stock Keeping Unit. This is used to uniquely identify each product and variant. The SKU will be shown to customers who view your products online.
BrandUse the brand attribute to indicate the product's brand name. The brand is used to help identify your product and will be shown to customers.
ManufacturerUse the manufacturer attribute to indicate the product's manufacturer name. The manufacturer is used to help identify your product and will be shown to customers.
Unit SizeUse the unit size field to define the measure and dimension of your product. This value allows users to understand the exact unit size your product is sold in. See the full list of supported units here.
Unit LabelUse the unit label field to define the unit of measure which appears on the invoice which is sent to the customer.
MPNUse the MPN code type to submit your product's Manufacturer Part Number (MPN). MPNs are used to uniquely identify a specific product among all products from the same manufacturer. Shoppers might search specifically for an MPN, so providing the MPN can help ensure that your product is shown in relevant situations.
UNSPSCUnited Nations Standard Products and Services Code (UNSPSC) codes are used to classify products and services: in the case of suppliers, to classify the products and services of their company, and in the case of UN staff members, to classify the products and services when publishing procurement opportunities.

Optional fields for a CSV import​

Examples of further optional fields and their requirements can be found in the table below.

FieldDescription
DescriptionUse the description field to tell customers about your product. List product features, technical specifications, and visual attributes. A detailed description will help us show your product to the right customers.
Image URLThe URL for product images. This image appears to potential buyers. Images are displayed to users in order equal to their position in the array. e.g., the first image URL in the images array will be used as the first image of the product in search results and the product page.
PropertiesUse the properties field to clearly identify the properties of the product that you are selling. Properties are one of the most important parts of your product listing. Your properties and property values will be displayed to the buyer on the product page and will be used to filter and search for products. Property names can be up to 155 characters in length. However, users will typically only see the first 30 characters or so of the property name. Property values have no limits on length.

Deleting & Archiving Products​

Products can be deleted or achived by importing a CSV file.

To begin uploading a CSV file for deleting/archiving, head over to the Products page or the File Imports page within the Products area of the platform. Click Delete, then select Products CSV file.

Selecting a File​

There is a CSV template available to download which include the two columns required by Axiom for deleting/archiving. These columns are command and product_identifier. The remaining fields do not need to be populated.

Once you have your CSV file ready for import, drag & drop or click Click to Browse to select the file. To begin importing the required deletion/archive commands from your CSV file, click Continue.

Uploading JSONL Files​

To begin uploading a JSONL file, head over to the Products page or the File Imports page within the Products area of the platform. Click Import, then select Products JSONL file. <

Selecting a File​

There is a JSONL template available to download which include the fields required by Axiom.

Once you have your JSON file ready for import, drag & drop or click Click to Browse to select the file. To begin importing the required deletion/archive commands from your CSV file, click Continue.

After Importing​

You will recieve a notification once your import has completed, notifying you of any errors with your product data.

All past and current imports can be viewed on the Imports page. To view more detail about an import, click on the table row.

On the import details page, any errors can be viewed in the errors table, including file rows and error messages. The original JSON file can be downloaded through the Download File button under ....

Additionally, you can download a copy of your original file with an additional errors column to help identify which rows need adjusting. To do this, click the Download Errors button.

Previous
Getting Started
Next
Manage Services with Files