Importing and exporting product data with multiple metafield types

The metafield feature in Shoplazza allows you to store additional fields in your admin, helping you customize your store’s functionality and appearance. You can use metafields for internal tracking or to display specialized information in your online store. To streamline the management of product information, the product import feature now supports importing and exporting multiple metafield types, making it easier to maintain and update your product data.

Import metafields

1. Log in to your Shoplazza admin: From your Shoplazza admin, go to Products > All products and click on Import from the Product page.

2. Download the product import template: Click Import template to get the product import file. This template will help you organize your product data before importing it into your store.

3. Open and fill in the template: After downloading, open the template file. You will see various columns where you can enter your product information, including multiple metafield types. Make sure to fill out the template following the specifications below to ensure successful import. This will help prevent errors during the import process.

4. Follow metafield formatting guidelines: Each metafield type has specific formatting rules that must be followed to ensure a successful import. Use the following guidelines when filling in the template:

Metafield types Import specifications
Date Format Use YYYY-MM-DD. Example: 2024-08-29
Date and Time Format Use YYYY-MM-DD HH:mm:ss. Example: 2024-08-05 00:00:07
Weight

Format as value-unit. Value can be an integer or decimal (up to 17 digits).

Units: kg/g/lb/oz.

Example: 11-kg

Volume

Format as value-unit. Value can be an integer or decimal (up to 17 digits).

Units: mL/cL/L/m³/fl oz(US)/pt(US)/qt(US)/gal(US)/floz(UK)/pt(UK)/qt(UK)/gal(UK).

Example: 11-mL

Dimensions

Format as value-unit. Value can be an integer or decimal (up to 17 digits).

Units: mm/cm/m/in/ft/yd.

Example: 11-mm

Integer The range is -4,611,686,018,427,387,904 to 4,611,686,018,427,387,903.
Decimal The range is +/-9999999999999.999999999,Maximum of 13 digits before the decimal and 9 digits after the decimal.
File Not supported at the moment.
Color Supports RGB values in #RRGGBB format. Example: #000000
Rating The range is 0-10.0. Supports one decimal place.
True or False Accepts true or false values.
JSON

Follow standard JSON format.

Example:{"name": "Bob","age": 22}


5. Upload the completed file: Once you have filled out the template according to the specifications, click Select File to upload your completed file to the Shoplazza admin.

Managing metafields through the product import feature allows you to efficiently update and maintain your store’s product information. By carefully following the formatting rules for each metafield type, you can avoid errors and ensure smooth data integration into your store.

Related articles

Setting up Metafields

Was this article helpful?
1 out of 2 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Live chat
Reset