List of Matrixify Commands across template sheets

In this page you can read about all possible Command column values and how they work with the data when importing.

Command

You can use the following “Command” column values across all entities that can be imported (Products, Collections, Customers, Companies, Discounts, Draft Orders, Orders, Pages, Blog Posts, Redirects and Files).

• NEW: will try to create a new item with the provided details. If an item already exists (with the same ID or same Handle), then the result will be Failed.
• MERGE: will try to find an existing item and update it with data from row. If an item cannot be found then the app will try to create a new one.
• UPDATE: the app will search for an existing item and update it. If an item cannot be found then that item will fail to import.
• REPLACE: WARNING! Use this Command value to fully replace the whole item, not individual fields. Using this Command value, the app will delete the item from the store completely and create a new one only from data in the file, resulting in losing all data that is not included in the import file.
  App will try to find an existing item and if found then the app will delete it. After that, it will create a new one only with data you have in the file.
  If an existing item will not be found, then still the app will create a new one. The difference from UPDATE is that it will not keep any of columns, which were not included in the import file since the item will be deleted and re-created.
• DELETE: the app will try to find and delete items. If an item cannot be found, then the result will be Failed. This command is very handy for deleting items in bulk.
• IGNORE: the app will ignore this item and will skip it.

If no “Command” is specified in the import file then the app will assume MERGE for all entities except Orders and Draft Orders where the app will assume NEW.

Tags Command

“Tags” and “Tags Command” columns can be used for Products, Customers, Draft Orders, Orders, and Blog Posts
Use “Tags Command” to tell the app what to do with tags listed in the “Tags” column.

Tell the app, what to do with Tags:

• MERGE: will add tags from the “Tags” column to existing tags for that item. It means that you don’t need to list all the tags in the import file, you can import those which you want to add. If some of the tags you are importing already exist, then the app will ignore them.
• DELETE: will delete the tags that are listed in the import file. If the listed tag will not exist, then the app will ignore it.
• REPLACE: will replace all existing tags with the tags from the import file. Use this method to maximize the import speed, because if you will use the MERGE tags command, it means that the app will need first to load existing tags which takes additional time.

If Tags Command is not set, the app will assume the MERGE command by default.

Image Command

“Image Command” can only be used for Products as only Products in Shopify can have multiple images.

Here you define the action, what to do with images:

• MERGE: will keep all existing images for your product, update data of specified images from this import, and add any new images.
• DELETE: if put next to the image, then this particular image will be deleted, while all other images will be kept.
• REPLACE: will delete all other images, and keep only those, which are included in this import.

Images are never deleted or removed by default – only when you will give the explicit command to do so.

If “Image Command” is empty or such a column doesn’t exist, then theMERGE value will be assumed.

Variant Command

Whenever variants are imported for Products, there is always one of those commands executed for each of the variant rows:

• MERGE: merges new variants into existing product variants. Updates those that can be found by “Variant ID”, “Variant SKU”, “Variant Barcode” or Option Values. If Matrixify will not find such a variant to update, then it will attempt to add a new one.
• UPDATE – will update variants that can be found by “Variant ID”, “Variant SKU”, “Variant Barcode” or Option Values. If a variant cannot be found to update, will fail the Product.
• DELETE: will delete the listed variant. Requires “Variant ID”, “Variant SKU”, “Variant Barcode”, or Option Values – so that it can identify, which variant you want to delete.
• REPLACE: will replace all existing product variants with the ones that are listed in the import. This will delete any variants that are not included in the import for that product.

If no “Variant Command” is specified, then the MERGE value will be assumed.

See this Tutorial for more details about adding variants: How Add Variants To Existing Product.

Address Command

Whenever addresses are imported for Customers, there is always one of those commands executed for each of the address rows:

• MERGE: merges new addresses into existing customer addresses.
• DELETE: will delete the listed address by “Address ID”, if no “Address ID” will be listed then the address will fail to delete.
• REPLACE: will replace all existing customer addresses with the ones that are listed in the import. This will delete any addresses that are not included in the import for that Customer.

If no “Address Command” is specified, then the MERGE value will be assumed.

Location: Command

When importing Companies, will tell the app what to do with Locations in this row.

• NEW: will create new Location and fail if it already exists in this Company.
• MERGE: will update if Location exists in Company and create a new one if it does not.
• UPDATE: will update if the Location exists and fail if it does not.
• REPLACE: will remove all Locations from the Company and add only those listed in the file.
• DELETE: will remove this Location from the Company.

If “Location: Command” is not specified, then the app will assume the MERGE command by default.
An existing location inside the Company will be searched by “Location: ID” or “Location: Name” values.

Customer: Command

When importing Customers linked to the Company, this columns value will tell the app what to do with the Customer in this row.
Matrixify app will find the Customer linked to the Company by the Customer: ID or Customer: Email column values.

• MERGE: will find the Customer linked to the Company and update customers role in the Company Location based on the Customer: Location Role column in this row.
• DELETE: will find the Customer linked to the Company and remove that customer from the Company.
  Value DELETE should not be used if only need to remove the Customer from the Company Location. To remove the Customer from the Company Location but not the Company itself, set Customer: Command to value MERGE and use the Customer: Location Role column with an empty value, indicating that the customer does not have a role in the Company Location.

If Customer: Command is not specified, then the app will assume the MERGE command.

Line Command

The “Line Command” is used for Orders import to tell what to do with the Line Item rows when updating an existing Order.

Allowed values:

• DEFAULT: will create those Line Items only when creating a new Order, and will not try to add any new Line Items when updating.
• MERGE: will create those Line Items when creating a new Order, and will also try to add any new Line Items to that Order if it is not already added to the Order.

Note that Shopify doesn’t allow adding Line Items to an Archived Order – that’s why we will unarchive, add, and archive your Order if it’s Archived.
See our tutorial on how to bulk add Line Items to existing Orders.

If no value is specified then DEFAULT Line Command will be assumed.

Comment Command

Tell the app what to do with the Comment rows when importing Blog Post Comments.

• MERGE: If a Comment with specified “Comment: ID” will be found then it will be updated. If it will not be found then it will be inserted as a new comment for that Blog Post.
• UPDATE: strictly only update existing comments. If the comment with specified “Comment: ID” will not be found then this item import will fail. Using this when you update comments will allow you to make sure you are not creating any duplicate comments by accident.
• DELETE: will delete that particular comment if it is found by specified “Comment: ID”. If it will not be found then it will be just skipped, assuming that it’s already deleted.

If no value is specified then the MERGE Comment Command is assumed by default.