Question 1

Product Fields

Accepted Answer

Products are items that you sell in your Shopify store. When exporting or importing products, you can work with their basic information, variants, images, inventory, pricing and more.

Sample File

Download a sample spreadsheet with product data to import.

Product Fields

These are all the fields you can import or export for products in Altera. Fields are grouped by category for easier reference.

General

Basic product information and settings.

| Field | Description | Example Value | | ---- | | ID | Shopify's unique product identifier | 7890123456 | | Handle | URL-friendly version of the product title | blue-t-shirt-xl | | Command | Action to perform on this product row | MERGE | | Title | Name of the product | Blue T-Shirt XL | | Body HTML | Product description in HTML format | <p>A comfortable cotton t-shirt</p> | | Vendor | Product manufacturer or supplier | Nike | | Type | Product category or type | Apparel | | Tags | Comma-separated list of tags | summer, cotton, sale | | Tags Command | Action to perform on product tags | ADD | | Created At | Date and time when product was created | 2023-01-15T10:00:00Z | | Updated At | Date and time when product was last modified | 2023-06-20T15:30:00Z | | Status | Product status (active/draft) | active | | Published | Whether the product is published | true | | Published At | Date and time when product was published | 2023-01-16T09:00:

Question 2

Error and Warning Codes

Accepted Answer

At various places throughout the app you may encounter a warning or error code. These codes are formatted like ABC001. This document provides more context on the error codes as well as tips to resolve them.

File Analysis Codes

These codes will appear when you upload a spreadsheet to be imported with the app.

ALYS001 - File Does Not Exist

There was an error opening the file you uploaded. Please try again and contact us if the problem persists.

ALYS002 - Zip File Must Contains a CSV File

You can upload a ZIP file with multiple CSV files to have them processed at once. However in this case the app did not detect any CSV files in the zip file you uploaded.

If you want to process multiple Excel sheets at the same time you can combine them into a single Excel workbook and upload that.

ALYS003 - Unsupported File Type or Invalid Content

We couldn't determine if your file was CSV, Excel, or a valid ZIP. Please upload either a CSV file, an Excel workbook with the .xlsx extension, or a ZIP file containing CSV files so our system can process it.

ALYS004 - No Valid Sheets Found

Our system tried to read your file but did not detect any sheets with the required structure. Ensure your file includes sheets that match one of our supported object types (for example, a valid Products or Orders sheet) and try again.

ALYS005 - Unmatched Columns

You spreadsheet contains columns that Altera does not recognize and these columns will be ignored when you import data

Question 3

Creating your first export

Accepted Answer

This guide will show you how to export Shopify data using Altera. You can choose which data types to include, select specific field groups, and apply filters—similar to how you would with other apps. Once your export is configured, you can download the file in either CSV or Excel format.

Step 1: Create a new export

From your Altera home page, click New export.
A new export creation page will appear where you can configure which data you want to export.

Step 2: Select data types

In the export creation page, you’ll see a list of supported data types such as Products, Collections, Orders, Files, and more.
Click any of the data types you wish to include in your export.
Each data type you select will appear below the list so that you can further refine the records and fields you want to export.

Step 3: Choose fields and filter fields

You will see a separate section for each data type selected (for example, Products).
In each section, there are groupings for the fields like General or Metafields.
Check the boxes next to each field you want to include in

Question 4

Creating your first import

Accepted Answer

This tutorial will walk you through the import product import process with Altera. We will

If you would like to follow along you can download our sample product spreadsheet.

Step 1: Create your spreadsheet

If you have not downloaded the sample product spreadsheet you will need to create one in order to upload it to the app.

In order to create a product your spreadsheet must include a 'Title' column. You can view the full list of product columns to see which ones are supported.

If you are creating your import in Excel, rename the current sheet to 'Products'. This will make it easier to Altera to identify what kind of data you are trying to import.

Step 2: Upload your spreadsheet

Open up the Altera app on your Shopify store
On the home page, click on Upload file and upload your product spreadsheet
The app will analyze your spreadsheet and try to determine which type of data is included in each sheet
Ensure that 'Products' is selected in the 'Type' dropdown for the sheet with product data
Click on Start import to begin the import

Step 3: Mo

Question 5

Smart Collection Fields

Accepted Answer

Smart collections automatically group products based on conditions you define. Products that match these conditions are automatically added to the collection.

Sample File

This sample file shows the basic columns that you need in order to import smart collections to Shopify. Smart collections that have multiple rules will have multiple rows in the file.

Download sample Smart Collection Import File.

Collection Fields

These are all the fields you can import or export for smart collections in Altera.

General

| Field | Description | Example Value | | ---- | | ID | Unique collection identifier | 12345678 | | Handle | URL-friendly version of the title | summer-sale | | Command | Action to perform on this collection | MERGE | | Title | Collection name | Summer Sale Items | | Body HTML | Collection description | <p>All our summer sale items</p> | | Sort Order | How products are sorted | MANUAL | | Template Suffix | Alternative template for collection | sale-template | | Updated At | When collection was last modified | 2023-06-20T15:30:00Z | | Published | Whether collection is published | true | | Published At | When collection was published | 2023-06-01T10:00:00Z | | Published Scope | Visibility scope | web |

Images

| Field | Description | Example Value | | ---- | | Image Src | URL of collection image | https://cdn.shopify.com/images/collection.jpg | | Image Width | Ima

Question 6

Customer Fields

Accepted Answer

Customers represent the shoppers who have created accounts or made purchases in your Shopify store.

Customer Fields

These are all the fields you can import or export for customers in Altera.

General

Basic customer information and account details.

| Field | Description | Example Value | | ---- | | ID | Shopify's unique customer identifier | 789012 | | Email | Customer's email address | customer@example.com | | Command | Action to perform on this customer | MERGE | | First Name | Customer's first name | Jane | | Last Name | Customer's last name | Smith | | Phone | Customer's phone number | +1-555-0123 | | Language | Customer's preferred language | en | | State | Account state (enabled/disabled) | enabled | | Note | Internal notes about the customer | VIP customer | | Tags | Comma-separated list of tags | vip, wholesale | | Tags Command | Action to perform on customer tags | ADD | | Tax Exempt | Whether customer is exempt from taxes | false | | Email Marketing: Status | Email marketing subscription status | SUBSCRIBED | | SMS Marketing: Status | SMS marketing subscription status | SUBSCRIBED | | Created At | Date and time when account was created | 2023-01-15T10:00:00Z | | Updated At | Date and time when account was last modified | 2023-06-20T15:30:00Z |

Addresses

Fields for customer addresses.

| Field | Description | Example Value | | ---- | | Address ID | Unique identifier for the address | 345678 | | Address Command | Action to perform on this address | MER

Frequently Read Articles

Browse All Categories