Archived Release Notes – Before 2023

On this page, you can see a list of all released changes in the Matrixify app until end of 2022.

To get notified about the changes as soon as they happen, follow Matrixify Slack workspace #whats-new channel.

2023

2022

2022, December

2022-12-30

• Import Products: Allow to set Variant Cost to 0.

2022-12-29

• Matrixify Template Demo: now instead of one big Demo Excel file, we have made an improved Demo file for each data entity.

2022-12-27

• Import Metafields: new Metafield Type [metaobject_reference].

2022-12-24

• Export & Import: Limit maximum Threads count to 250. Going higher does not increase speed because of context switching and Shopify connections limit.

2022-12-23

• Export Orders: New export-only columns for Orders export [Price: Total Duties] and [Price: Current Total Duties].

2022-12-21

• Import Companies: reading the [Location: Shipping Recipient] and [Location: Billing Recipient] columns, saving with the temporary workaround using Shopify unstable API.

2022-12-20

• Fix: Import Again: was freezing UI if pressing the “Import Again” button on the job that was from URL that does not exist anymore.

2022-12-17

• Export & Import Orders: added new columns [Source Identifier] and [Source URL]. E.g. when Order comes from external sales channel like Instagram, then you will be able to see its ID and source URL there.

2022-12-15

• UI: Export & Import Options: [Schedule on] to allow selecting time precision by minutes (not just by 5 minute intervals).
• Import & Export Options: Results File name date&time source can also be taken from [Saved At] time.
• Export & Import: Shopify has increased API call limit for all Shopify Plus stores to 400 (500%). Previously it was 300%. So you should experience much faster exports and imports, and increased parallel threads for Enterprise plan.
• Fix: Import Orders: read [Refund Shipping] column [Line: Total] or [Line: Price] (whichever has the value first) for partial shipping refund amount.

2022-12-14

• Fix: Import Batch: should perform file actions (Delete/Move) also for first job in the repeated job chain.

2022-12-13

• Export: Automatically switching next repeated jobs from Excel to CSV if data did not fit into Excel for the current job (exceeds 500k rows). If you know in advance that export will have more than 500k rows, then please choose the CSV format. Switching from Excel to CSV at the end makes the export run longer.
• Import Draft Orders: link to the Company by importing columns [Company: ID], [Company: Name], [Company: Location ID], [Company: Location Name], and [Customer: ID], [Customer: Email], [Customer: Phone].

2022-12-09

• Fix: Import Magento v1 Products: was not importing [Image Alt Text] from Magento column [_media_lable], because we thought there is a typo, but actually that Magento column is called lable instead of label.

2022-12-08

• Fix: Import from FTP/SFTP: when doing “Import Again” from the finished job with file moving actions, should not remember previous job file current location (was causing the copied import to fail).

2022-12-07

• Import Orders & Draft Orders: if importing Customer: ID as empty column, but have the Customer: Email or Customer: Phone column filled, then attach customer based on filled values.
  To remove the Customer from the Order/Draft Order, then the file needs to have Customer: ID column with empty value, and not have the Customer: Email or Customer: Phone with any values there.
• Fix: Import Products: when updating to empty [Variant Inventory Policy] – it was failing.
• Import Orders: split the [Fulfillment: Tracking URL] into several URLs by ; smarter – split only if the part after ; looks like URL, because some tracking URLs have ; as part of URL.

2022-12-06

• Import Products from WooCommerce API: generate Redirects for Draft products with no path as assumed /product/<slug> (instead of /).
• Import Products: Remove trailing / from the image URLs (otherwise Shopify cannot determine the image file name, and names the image as unnamed).

2022-12-05

• Import: Orders from Magento DB: Take prices and other line item details from the configurable item row if no simple product row is provided.
• Fix: Export: some exports with filters got slower since 2022-11-11 – fixed by caching the filter results.

2022-12-03

• Fix: Import Companies: was failing when removing the Company Contact for Company that did not have any Contact.

2022-12-02

• Fix: Export Orders: calculate percentage discount allocations more correctly through line item discount allocations.

2022-12-01

• Import from Dropbox link: now can import files from Shared Dropbox links (that have /sh/ in the URL).
• Fix: Migrate Orders from WooCommerce: transaction status sometimes is Completed with capital-C – so we need to check that as case-insensitive.
• Fix: Import Repeated Batch jobs from FTP/SFTP: if having the File Actions (like to move or delete imported files), and if any file fails already while estimating, then still execute that required action on that file.

2022, November

2022-11-29

• Import Orders:
  • Now you can import Orders as Shopify Transporter file template.
  • For Matrixify app to recognize the Orders file as Transporter file, you need to include the following keywords in the filename: transporter and orders. For example: transporter_orders_1.csv.
  • If you need to delete Orders the same way as you do in Transporter, then you can add the command=delete to the file name, for example: transporter_orders_command=delete.csv – then we will force the Command as DELETE , regardless of what command is specified in the file.
  • If you will upload the Transporter file without giving it transporter keyword in the filename, then we will try to import it as Matrixify template, so you will see that Transporter-specific columns will show as ignored.
  • With Matrixify you can import Transporter files in all Shopify stores (don’t have to be a Plus store).
• Import Orders: when linking Line Item, can link the variant to Order by just Line: Variant Barcode value (live since 2022-11-07).
• Import Orders: when creating new Order, then can set the values from columns Weight Total and Browser: Referrer.
• Export & Import Orders: new columns Shipping: Name and Billing: Name which is the new way how Shopify joins First and Last name for the Shipping/Billing addresses.
  When imported – at first the Shipping/Billing: First/Last Name columns will be considered. But if those don’t exist, then the Shipping/Billing: Name will be imported instead. Shopify splits the Name automatically to First/Last Name.
• Import Orders: can also import Discount line with percentage as the Discount type. The value of percentage is read from Line: Price column.
• Import Orders: changes in logic for columns Line: Requires Shipping and Line: Taxable – earlier if those did not have any value, we passed FALSE to Shopify. Now, if those are empty, we will not send those to Shopify, which will delegate this decision to Shopify – whether set to true or false automatically, depending on the linked product.

2022-11-25

• Fix: UI: was showing “Error loading servers” when the app was just installed. Also, was showing a “loading” card if there are no historical jobs yet.

2022-11-22

• Fix: Import: deleting Tags with Tags Command = DELETE was case-sensitive; now it is case-insensitive, because Shopify does not allow the same tags with different UPPER/lower case anyway.

2022-11-17

• Import Orders & Draft Orders: should not show in the Order Timeline that details were edited when not importing [Additional Details] column.

2022-11-16

• Fix: Import Companies: was failing when updating Locations by Company ID.

2022-11-15

• Import Customers:
  • Now you can import Customers file template with additional columns as in the Shopify Transporter and Shopify Admin CSV formats:
    Company
Address1
Address2
City
Zip
Province
Province Code
Country
Country Code
Metafield Namespace
Metafield Key
Metafield Value
Metafield Value Type
    It all will behave by default as in Matrixify, and can be combined with all the Matrixify columns.
  • To force creating only new Customers, and to fail if such customer exists (like in Transporter), then give the CSV file name such that it contains words customer and transporter. Then we will force the Command=NEW.
  • If you need to delete customers the same way as you do in Transporter, then you can add the command=delete to the file name, for example: transporter_customers_command=delete.csv – then we will force the Command as DELETE , regardless of what command is specified in the file.
  • Basically, you can upload your existing Transporter Customers CSV files into Matrixify, and they will import everything the same way as in Transporter, and will blend with existing Matrixify functionality. The same with the CSV file that you can export from Shopify Admin – Customers section.
    Still, if you need to copy data from one store to another, we strongly suggest you to do the export with Matrixify format, because that contains much more data fields than Shopify Admin CSV export, so the data will be more precise.

2022-11-14

• Import Products: ignore the variant row if it has value only in [Variant Command] column but other cells are empty for that variant row.

2022-11-12

• Import: increased maximum CSV file size inside the zipped file to 10 GB.

2022-11-11

• UI: improved app loading speed.

2022-11-10

• Import: Products
  • Now you can import the Products file template with additional columns as in the Shopify Transporter app:
    Metafields Global Title Tag
Metafields Global Description Tag
Metafield Namespace
Metafield Key
Metafield Value
Metafield Value Type
Variant Inventory Cost
Image Attachment
    It all will behave by default as in Matrixify.
  • To force creating only new Products, and to fail if such product exists (like in Transporter), then give the CSV file name such that it contains words products and transporter. Then we will force the Command as NEW.
  • If you need to delete products the same as you do in Transporter, then you can add the command=delete to the file name, for example: transporter_products_command=delete.csv – then we will assume the Command as DELETE if it’s not specified n your CSV file column.
  • Basically, you can upload your existing Transporter Products CSV files into Matrixify, and they will import everything the same way as in Transporter, and will blend with existing Matrixify functionality.

2022-11-06

• Import: In the Results file automatically generate primary identification [ID (Ref)] and secondary identification [Handle (Ref)] (or [Name (Ref)], etc for all entities…) columns from the respective Shopify item data.

2022-11-03

• Import: if there is an empty row then tell in the error message which row it is.
• Import Orders / Draft Orders: if [Tax: Total] is empty then calculate and send it to Shopify when importing Order level tax.

2022, October

2022-10-28

• Import from Magento: converting any JSON with quotes inside HTML attribute to JSON with single-quotes, because otherwise there is three level-quote-escaping, which cannot be properly parsed in HTML.

2022-10-25

• Import Customers: optimize import speed when updating Marketing Consent for existing items.

2022-10-20

• Import Products: now to delete an Option from variants, you need to list all the variants, and set that [OptionX Name] and [OptionX Value] to empty for all the variant rows. That is – to avoid removing an option by accident.
• FTP/SFTP: improved detecting if the path is a file or directory.
• Import Companies / B2B: Shopify increased limits per Company. Locations to 500, Linked Customers to 500, Roles per Location to 50.

2022-10-19

• Export Orders: ability to set custom object separator for [Additional Details] column – by contacting Support.
• Export Orders & Draft Orders: reading values from related Customer for [Customer: Orders Count], [Customer: Total Spent].
• Fix: Import Products: was not able to find the [Inventory Available:] column location by name that has non-English characters.

2022-10-18

• Fix: Import Orders and Products: when cannot find a Location, then show the location name exactly as it is in the file, without changing it to TitleCase.

2022-10-17

• UI: Made changes to comply more with the Shopify App User Interface Guidelines. Notice that the top menu is now moved to the side-menu navigation.

2022-10-15

• Migrate from WooCommerce: keep the Metafields exactly as they are in WooCommerce, also keep the _ as prefixes/suffixes (earlier we were converting Metafield names to lower_case_handles).

2022-10-14

• Fix: Import: Orders: sending Shipping Line price to 0 if it is not being imported.

2022-10-13

• Fix: Import Files: failing with error "Validation failed: Alt is reserved" when adding new files with empty value in [Alt Text], send correct default/empty value to Shopify.
• Fix: Migrate BlogPosts/Pages from WordPress: was not able to read the rendered Body HTML via the API if blog was hosted in a subdirectory.

2022-10-08

• Fix: Import Orders: should not add another [manual] prefix to the [Transaction: Gateway] value if it already is manual. E.g.: gateway manual (Stripe) was imported as manual (manual (Stripe)).

2022-10-06

• Fix: Import Orders: match duplicate Line Items by [Line: Properties] for Refunds and Fulfillments.
• Fix: Product Import: should send correct default/empty values for [Status], [Type], [Variant Fulfillment Service] – when creating and updating, so that Shopify API accepts them better.
• Fix: Import Orders: match refundable transaction when file has no gateway specified, but has refund ID; always assume empty gateway as [manual (Assumed)] (to be different from manual gateway).

2022-10-03

• Import / Export Metafields: new Metafield type [order_reference].
• UI: Import: show columns in the uploaded file, and warn if there are unknown columns that will be ignored.
• Fix: Import: should validate max column name, but not fail the job if columns in other sheets exceed max length 361 characters.
• Fix: Import Products: was putting wrong price value if there is Variant Fulfillment Service but not Variant Price column.

2022, September

2022-09-30

• Import Orders / Draft Orders: fail when recognizing as Shopify CSV export files, because they don’t have the full data. To import Orders from another store – export them with Matrixify.

2022-09-29

• Export Orders: new feature-toggle to not escape [Line: Properties].
• Import Metafields: added new Metafield type: [customer_reference.

2022-09-27

• Import: added new Metafield types – [money], [list.collection_reference], [collection_reference].

2022-09-26

• Import Customers: when setting the Email Marketing: Status, but not Email Marketing: Level is not specified, then assume it is single_opt_in. That is – to avoid failing because of Shopify API validation.

2022-09-22

• Fix: Import from Google Sheets: be able to import from URL that Google Sheets gives on iPad.

2022-09-21

• Export & Import: set the Option to specify which time to use for file name dynamic placeholders – Started At (Default) or Scheduled At.

2022-09-20

• Export & Import Companies: columns [Location: Shipping/Billing First/Last Name] changed to [Location: Shipping/Billing Recipient] because of Shopify API changes.

2022-09-17

• Fix: Import Orders & Draft Orders: when aggregating the same Line Items into one Line Item – also compare additional Line columns.
• Import from Zip: sometimes zipped Excel file was falsely detected as Excel.

2022-09-15

• Import Metafields: auto-detect if there is a Metafield Definition for this Metafield in the Admin – and if there is, then use the Metafield type and correct UPPER/lower case name from the Admin Metafield Definition.

2022-09-14

• Import: increased max allowed total files size inside the zip file to 30 GB, so that you can do larger migrations to Shopify.
• Import Orders & Draft Orders: squash several identical Line Item rows into one, summing the quantity and discounts, to avoid confusions when need to create Fulfillments and Refunds for those Line Items.

2022-09-12

• Fix: Import from WordPress: was failing to download images with international file names with the error “URI must be ASCII-only”.
• Fix: Settings -> Servers: when checking the FTP/SFTP server connection, then should not fail if / has no permissions.
• Import Orders: matching Refunds to Transactions – do not force the gateway to match strictly if it starts with manual.

2022-09-08

• UI All Jobs: improved performance for filtering by Job State.
• Import: Customers: workaround to set and change the Email Marketing: Status and SMS Marketing: Status.
• Import Blog Posts: if the import has Blog attributes of a non-existing Blog, then create a new Blog and move Blog Posts to that (instead of updating existing/first Blog like it was till now).
• Import: maximum allowed upload file size increased from 3 GB to 7 GB.

2022-09-06

• Export Discounts: added new export-only column Status – shows discount status as Active, Expired or Scheduled based on Ends At and Starts At fields.
• Export Discounts: New filter Status – available conditions Active, Expired and Scheduled.

2022-09-05

• Fix: Import Orders from WooCommerce: do not multiply Line Item weight with quantity for Line: Grams field, because Shopify already does that.

2022-09-01

• Import Metafields: change maximum allowed namespace length to 255, and key length to 64 characters, to match changes in Shopify.
• Fix: Import Orders: match Line Items even if title has named character references like ®.
• Export Orders & Draft Orders: added new column group [Companies] – to include Order related Companies columns.

2022, August

2022-08-31

• Fix: Import from FTP/SFTP: improve parsing the credentials from URL if password contains #.
• Fix: Import from URL: do not interpolate date for escaped characters in URL.
• UI: Limited badge for limited Exports, adjusted colors for badges in Jobs list.

2022-08-30

• Fix: Import from filenames with non-English characters were sometimes failing.
• Import Metafields: when specifying Metafield type as number_integer with float value like 5.12345, then round it to an integer.

2022-08-28

• Fix: Import from FTP/SFTP: in some cases we could not download or import files with + in the sheet name.

2022-08-26

• Import Products: When deleting all variants, then keep the last variant all fields, but set Options to “Default Title”. This is to match exactly how Shopify Admin “Delete All Variants” is working.
• Export Orders & Draft Orders: new column Line: Discount per Item for Orders and Draft Orders.

2022-08-23

• Export Orders: new column [Line: Discount Allocation].
• Fix: Import: in some cases, if time value was with time zone specifically +0000 , then we assumed it has the Shop time zone, not the UTC. Now it’s properly UTC.
• UI: All Jobs: improved jobs filtering by filename prefix – now it should filter jobs much quicker.
• Fix: Import Products: be able to link images to variants when creating new product with images of “empty”/strange file names like ____.jpg.
• Fix: UI: All Jobs: allow to clear the file name filter text by pressing the (x) button.
• Fix: Import Companies: there was error [unexpected keys] from Shopify when sending empty value for [Customer Since] column.

2022-08-20

• Import Orders from WooCommerce API:
  • Fix: if coupon_codes are empty then assume the Discount from the discount_total.
  • When [Billing/Shipping Last Name] empty, swap it with First Name because Shopify requires Last Name.

2022-08-18

• Import Metafields: convert [date] and [date_time] Metafield types to ISO format as required for Shopify.

2022-08-16

• Export: added additional date format for UK: d/m/Y. If you choose this date format, then be sure not to import this file in Matrixify, because auto-detecting date format will confuse it with US format which is m/d/Y .

2022-08-15

• Fix: Migrate Products from Magento: product prices taken from options did not take into account special price expiry date.

2022-08-13

• Import Products from Magento CSV: Take [Body HTML] also from Magento [short_description] column if [description] is empty.

2022-08-12

• Import: Magento Orders – ability to switch to import order prices without tax included. Ask our Support if you need to enable this for your store.

2022-08-10

• Import: do not give warnings about assumed Commands when creating new items – to cause less confusion.
• Import: upload file size limit increased from 2 GB to 3 GB.
• Fix: Export to Excel – when option was set to add apostrophe prefix for Numbers, it was showing 0.00.

2022-08-06

• Import Orders from WooCommerce API: pass the URL query parameters [since] and [order_status]. Also, you can combine since , before and order_status query parameters to migrate Orders for a date interval. since includes the date (as >=) and before excludes the date boundary (as <). Dates need to be in ISO format, UTC time zone – like this: 2022-08-06T16:35:11.
• Fix: Export: format all the amount columns as 0.00 – in Excel and in CSV. Even if prefixed by ' (apostrophe).

2022-08-05

• Import: improved stability for uploading files with the browser – will retry several times if your internet connection is unstable or dropping.
• Import: do not show the warning about the “Assumed Tags Command” when creating new items, because it might be confusing in that case.

2022, July

2022-07-29

• Import Companies: if there is an error then tell more precisely which Location or Company/Contact has that error.
• Export Orders: include Line: Discount value also for Refund Line rows.

2022-07-28

• Export & Import: B2B – Companies: usability improvements and bugfixes:
  • Renamed “Customers” column group to “Linked Customers” to better indicate that you can link customers to Companies, but cannot create new Customers with Companies sheet. To create new Customers, use the “Customers” sheet.
  • Can replace all Locations in Company – even if there are already maximum limit of Locations created.
  • Can remove the Main Contact even if it was not mentioned in the Company Customers columns.
  • Company import will fail if updating Location by Name, but there are several Locations with the same “Location: Name”.

2022-07-27

• UI: You can now open the Job in new tab – by Ctrl+Click (on Windows) or Cmd+Click (on MacOS) on the Job #id link. Or you can right-click on that Job #id and choose from the menu to open in new window/tab, or copy the link to this job. Pro tip: if you additionally hold the Shift key, then it will open in new Tab/Window, and activate it too (on Chrome).
• Export: for running or finished Export jobs – you can see which column groups were not selected (previously we were showing only those column groups that were selected).
• Migrate from WooCommerce: continue importing Products the next day if exceeding daily Shopify Variant Limit.
• Import: show error that comes from Shopify if item import or deletion failed (instead of sometimes showing generic error that something went wrong).

2022-07-26

• Export: you can now go to “Customize Columns”, click on the pencil icon for any Command column, and select a custom value for that column in the export.

2022-07-22

• Export & Import: new entity Companies for Development and Shopify Plus stores (the Companies section is available in Shopify Admin only for those shops).

2022-07-21

• Export & Import: Files that are video links (via “Files” sheet).
• Import: accept .xlsx files that have MIME type application/wps-office.xlsx.

2022-07-18

• Export Options: the ability to choose the UK time format.

2022-07-17

• Export Orders: new column Price: Total Outstanding.

2022-07-11

• Import: Assume MERGE value as the default for Tags Command if file imports Tags but Tags Command is empty or not in the file. Show warning if app assumes Tags Command value to inform about the change in logic. This logic has changed for your safety. To replace Tags, set Tags Command to value REPLACE.
• Export: Orders: Ability for Matrixify support to enable a feature to all store Order exports fill Basic Columns in all rows for the order not just first one. Ask support if needed.

2022-07-09

• Migrate Customers from Magento: save the euvat_vat_id to Magento Address: euvat_vat_id column, created_at to Metafield: magento.created_at [date_time], last_order_date to Metafield: magento.last_order_date [date_time].

2022-07-08

• Import: reverted the Shopify API workaround for Variant Weight Unit change that removed InventoryItem – because Shopify fixed the issue now.

2022-07-04

• Import: Give better error if the file contents are not right.
• Import: Tell in the error if the Google Sheets link is not shared publicly, and thus cannot be read for the import.

2022-07-01

• Export Customers: Accepts Marketing column is removed, and changed to column Email Marketing: Status. Imports continue working also with the old Accepts Marketing column, too.

2022, June

2022-06-28

• Fix: Export Collections: was not including all linked products because of Shopify API issue, made a workaround.

2022-06-27

• Fix: Export Products, filtered by Collection and Status was not getting all the products in the collection, because of bug in Shopify API.
• Import Draft Orders: give warning if shipping line was not created by Shopify, because Shopify ignores Shipping Line if there are no shippable line items.
• Import: ability to set shop default value for Option “Transliterate Handles to English”. To change the default value for your store, please, ask Matrixify Support.

2022-06-25

• Export: Option to include the apostrophe prefix for numbers – to avoid Google Sheets converting prices to dates.

2022-06-22

• Import Products from Magento: put country_of_manufacture value to [Variant Country of Origin]; save simple product price in Metafield and respective Variant Metafield (because we take the configurable product price by default and adding adjustments to it – this shows to be the most correct in most cases, but just in case, you can use the values from the Metafields)
• Import Products: Allow importing country name in [Variant Country of Origin] column (previously it required 2-letter country ISO code).

2022-06-15

• Fix: Import Orders from Magento DB: be able to convert serialized PHP object that has a newline in it.

2022-06-11

• Import Orders: allow creating Transactions with empty gateway (when Transaction: Force Gateway is TRUE), and also match refund transactions with no gateway.

2022-06-08

• Export Customers: Email Marketing: Status column takes the data from from new Shopify attribute email_marketing_consent.
• Export Orders: added new coluns Price: Total Discount and Price: Total Shipping columns.

2022-06-06

• Import Orders: allow to import Discount of 0.00 amount.

2022-06-03

• UI: Export: show indeterminate checkbox state for groups if not all columns are selected.
• Import Products: ability to set the default State (e.g. Draft) for a  newly created Product (ask Support if you need to set it for your store).

2022-06-02

• Import from Turn14: take the price from MAP price at first. If MAP price is empty, then take the cheapest from Jabber and Retail price.

2022-06-01

• Fix: Import Products: Shopify API has a bug that when setting Variant Weight or Variant Weight Unit, then Variant Cost disappears for that variant – we made a temporary workaround and reported the bug to Shopify.

2022, May

2022-05-31

• Import from Turn14: take the Variant SKU from part_number field (instead of mfr_part_number) – to have unique SKUs; Add MFR SKU to Tags and to Metafield: turn14.mfr_part_number.

2022-05-27

• Fix: Import Products: if Shopify changed the Handle to something else, then we generated Redirect to the Original Handle.
• Fix: Import: detect the file as Files entity if the file name contains [files] word (but not the file word).

2022-05-26

• Fix: Export: app was not showing Export or job list if there were old jobs from 2018.

2022-05-25

• Fix: Export: should not crash for old jobs with an empty format.

2022-05-24

• UI: Export: show filters when Sheet collapsed; select column group when clicking on whole column group row; Customize Columns collapsed by default.
• Import Orders: if having error when putting all OrderFulfillments in one Fulfillment, then split Fulfillment by separate OrderFulfillments. So, if you fulfill the whole Order, but actually get 2 Fulfillments created, it means that Shopify was not able to join all of the Line Items in one Fulfillment – they needed to be fulfilled separately (e.g. if you have one of the Line Items as a subscription item).
• Fix: UI: Export: date filters should work with Shopify store time zone, instead of computer time zone.

2022-05-23

• Export: new user interface to improve the Export experience.

2022-05-21

• UI: show which job files are deleted (when re-installing the app after the historical files were purged).
• Import: validate image links more strictly before sending them to Shopify (also increase the feedback speed when image links are coming from unknown hosts).

2022-05-20

• Export: enable to include Metafields in all rows for specified entities (ask Matrixify Support if you need it enabled for your store).

2022-05-19

• Fix: Migrate Orders from Magento: take the [Fulfillment: Processed At] at first from the shipment file.

2022-05-12

• Export Orders & Draft Orders: Additional columns [Line: Variant Price] and [Line: Variant Compare at Price] in group [Line Item Product Data].

2022-05-11

• Import Orders: fulfill remaining Order based on Line Items grouping by new OrderFulfillments – to be able to fulfill subscription Line Items in the same Fulfillment with the other Line Items.
• Fix: Import Blog Posts: was failing when there were many Comments.

2022-05-10

• Export Files: 3 size columns with data from Shopify, much faster: Size Bytes, Size MB, Size (human readable). Also can filter by Size MB column.

2022-05-09

• Fix UI: “Contact Support” button was not working due to Shopify UI library issue which we have reported.

2022-05-04

• Import Metafields: allow to import with type prefix [list.] for all Metafield types.
• Import Products: allow several repeated columns with the same names [Image Src, Image Alt Text, Image Position] to import several images.
• Import Products: support the Shopify CSV coming from Banggood.
• Import: do not complain that columns are not valid if Shopify CSV file has [banggood] in the name, but it’s not a Banggood file.

2022-05-03

• Import Orders from Magento DB: include payment additional info even if it is a list of comments.

2022, April

2022-04-28

• Export Orders: calculate total refunded amount correctly if refund transactions are in different currency.

2022-04-27

• Import Orders from Magento DB: parse Payments additional_information column also as JSON string.
• Fix: Migrate Orders from Magento DB: parsing of null values in additional_information. Also, ignore any values that have null text in them.

2022-04-26

• Import from WooCommerce: limit description size to 1 MB and maximum 100 images per product; for relative image links – assume the source server.

2022-04-21

• Import DraftOrders: should fail when unable to send an invoice.

2022-04-20

• Import: tell which Tags are too long, if Shopify gives error [tags is invalid].

2022-04-19

• Export Payouts: do not request Orders data if columns Transaction: Source Order Name, Transaction: Source Order Checkout ID are not included – to make the export much faster, do not include those columns.

2022-04-17

• Migrate Orders from WooCommerce API: ability to work with two different structures of _wc_shipment_tracking_items metafield | Fixed Fulfillment: Processed At date format.

2022-04-16

• Import Orders: fail the Order if there are Transaction columns filled for the Refund Line row – to avoid making an error, because we ignore the Transaction columns for refund lines. To refund a specific amount, you need to provide the row with Line: Type as Transaction, and Transaction: Type as refund.
• Migrate Orders from WooCommerce API: ability to work with two different structures of _wc_shipment_tracking_items metafield | Fixed Fulfillment: Processed At date format.

2022-04-13

• Shopify API migrated to version 2022-04.
• Fix: Import Products: new Metafield type list.product_reference.

2022-04-12

• Fix: UI: All Jobs – show job filter State counts for all jobs, not just for the first page jobs.
• Fix: Import Products: further improved matching imported source image URLs to Shopify CDN images – by removing all GUIDs, not just the last one.

2022-04-07

• Import: give warning about repeated ID or Handle due to wrong sorting in respective Import Results rows (also for Dry Run).
• Import Images: better match images to existing ones, and to variants (e.g. when image filename has additional dots in it, and Shopify sometimes converts it to _, but sometimes keeps the .).
• Import Metafields: new Metafield type [list.single_line_text_field].

2022-04-05

• FTPS: use implicit mode when connecting to port 990, and fall back to explicit FTPS if implicit is failing.
• Export & Import Options: additional dynamic placeholders for custom filename – %{shop_subdomain}, %{shop_name}, %{entities}.

2022-04-01

• Fix: Import from Google Drive: determine file extension from the Mime Type if the file does not have an extension.

2022, March

2022-03-31

• Fix: Import from Google Drive: because of occasional [403 – Forbidden] error – download files from Google Drive using the Google API.
• Import from Google Drive: allow to share files privately with Matrixify – just share your Google Drive file with e-mail [email protected] with Viewer permissions.
• Migrate from WordPress, WooCommerce, BigCommerce: when downloading images – add -1 suffix to filename even if image has different capitalization, because otherwise Shopify would treat them as duplicates.

2022-03-29

• Export to Google Shopping Data Feed: option to include values from Standard Type (need to check the box in the Export to include the “Standard Type” column group, then it will be a bit slower, as it needs to read each value separately from Shopify API).

2022-03-28

• Fix: Migrate Orders from WooCommerce API: improved logic for determining amounts for Stripe payments.
• Import Orders: require Line: Quantity value for Refund: Line row.

2022-03-27

• Import from WooCommerce: migrate product attributes to Metafields in woo_attribute namespace.
• Import from WooCommerce: include hidden attributes into Metafield woo_attribute_hidden.
• Import from WooCommerce: improved downloading the same image for different sheets.

2022-03-24

• Import from WooCommerce API: try to convert Visual Composer descriptions to HTML.
• Import from WooCommerce: added column [Woo: Description] to show the original HTML that we got from the API, with unconverted Visual Composer and links.

2022-03-22

• Fix: Import from Google Drive: retry downloading the file if Google Drive is giving error 403 – Forbidden.

2022-03-21

• Import from WordPress: ability to switch off automatic conversion from Visual Composer for specific shops (ask Support if you need to).

2022-03-20

• Fix: Import Product Images: detect the correct image file name by following image redirects better.

2022-03-16

• Fix: UI: was not able to approve missing access scopes.

2022-03-15

• Migrate from WordPress/BigCommerce/LightSpeed: if there are images with the same filename from different paths, then rename those images so that they are unique.
• Migrate from WooCommerce: squash Metafield columns that have numbers in their names to one Metafield.

2022-03-13

• Fix: Migrate from WooCommerce: it was not possible to get the Weight Unit if the API JSON response had unexpected <script> HTML tag in it.
• Import Orders: retry when getting Shopify API error array contains unpermitted members.

2022-03-09

• Migrate from WordPress: also download images from Image URL column in the AllExport CSV file, and replace their URLs in HTML, and create respective Redirects.

2022-03-06

• Migrate from WordPress, WooCommerce, BigCommerce, Magento, LightSpeed: better convert image links also in other HTML tags, and ignore http(s) differences.

2022-03-03

• Fix: Import Customers: sometimes was giving error undefined method merge for nil:NilClass when setting SMS Marketing: Status.

2022-03-02

• Migrate from WordPress, WooCommerce, BigCommerce: generate redirects also for image links.
• Migrate from BigCommerce API: take the SEO Metafields from page_title and meta_description fields.
• Fix: Import Product Images: was sometimes failing on files with different URLs but the same file names.
• Upgrading our job scheduling server, so the scheduled jobs scheduling will get delayed for some 10 minutes, and then will return back to their usual schedule (upgrade went good without noticeable issues).

2022-03-01

• Fix: Import from exported Matrixify CSV: we were giving error that there is no newline if there was 1+ MB of data in just column names, first row.
• Fix: Import from WooCommerce: Dry Run technical errors.

2022, February

2022-02-26

• Migrate from WooCommerce: improved getting data from API – even if it is giving different data per page, also avoid duplicates.

2022-02-25

• Fix: Import Products: set the Variant Requires Shipping or Variant Taxable even if either of those are the only columns for variants.

2022-02-24

• Import Product Images: improved setting imported and updated image positions.

2022-02-23

• Import Products: better attach new images to variants – even if new images have the same (duplicate) file names, and redirects.

2022-02-22

• UI: Fix – when canceling the job in the job list, the spinner was shifting to the next job in the list.

2022-02-17

• Export Orders: Guess the Transaction: Authorization value from the transaction receipt if authorization is empty.

2022-02-16

• Fix: Import Products from Magento: in CSV file the \ before closing quote got interpreted as escaped quote.
• Export Discounts: new filter conditions – [starts with any of, contains any of].

2022-02-11

• UI: All Jobs – optimized performance for filtering jobs, even if there are very many Import/Export jobs in your store.

2022-02-09

• Fix: Export Discounts: we were exporting just the first 250 Discount Codes for each Discount. Now exporting all of them.

2022-02-08

• Fix: Import Orders: Order Source was changed to Matrixify App by default when updating order and not importing Source column with a value.

2022-02-07

• Fix: when importing Draft Orders we were indexing existing Draft Orders in shop. If existing Draft Order count exceeded the maximum import limit allowed by the plan, we gave a warning that the import is too big (even though it wasn’t).
• Fix: Import Draft Orders: retry up to 10 times if getting Shopify API error This order has not finished calculating, please try again later when completing the Draft Order to Order.

2022-02-02

• Export & Import Customers: New E-mail and SMS Marketing columns: Email Marketing: Status, Email Marketing: Level, Email Marketing: Updated At, SMS Marketing: Status, SMS Marketing: Level, SMS Marketing: Updated At, SMS Marketing: Source.

2022-02-01

• Fix: Import Customers: do not go into a limbo if cannot replace a Customer because its e-mail already exists, but cannot find it by e-mail to delete.

2022, January

2022-01-27

• Export: Orders & Draft Orders: new export only column total of all taxes per line – Line: Tax Total for Orders and Draft Orders.
• Import images from URLs that have redirects, including images from Google Drive – Shopify fixed the issue, so images are importing now properly, as they should.

2022-01-25

• Export & Import: Smart Collections – support Is Empty and Is Not Empty conditions for Variant Compare At Price Rule.
• Fix: Import & Export: Product Standard Type columns can now be imported (as Shopify fixed the API issue).

2022-01-19

• Fix: Export Again – it was forgetting the filters from the original job when doing Export Again.

2022-01-18

• UI: Optimized “All Jobs” filter by filename – works better for shops with very many jobs. If your search gets stuck, please, contact our Support.

2022-01-15

• Now you can have a bookmarkable link to each place inside the app. For example, you can bookmark the “Export Again” page of any previous job – to use it as a template for your typical exports. Or, for example, you can bookmark a page with specific All Jobs filters.

2022-01-13

• Import: retry up to 10 times when searching by Handle and found more than 1 – because lately Shopify API responds with all results if filtering by Handle.

2022-01-12

• Import Orders: improved speed and reliability when searching Orders by Name – searching only by one GraphQL method, and retrying only if query took too long.

2022-01-11

• Import & Export Products: slightly improved speed when importing/exporting Multi-Location Inventory Levels.

2022-01-10

• Export Payouts: new column Transaction: Source Order Checkout ID.

2022-01-05

• Fix: Import Orders: match capture transactions to authorization directly, if there is just one authorization transaction.
• Fix: Import Orders: match capture transactions to authorizations – only to those with success status.
• Export Orders: new column Line: Pre Tax Price.
• Fix: Import Orders: with multiple threads was not able to find locations for first Orders, until locations got loaded in the background.

2022-01-04

• Export & Import Orders: new column Transaction: Parent ID.
• Import Orders: always generate the unique Transaction: Authorization value within that Order (if it’s not provided as unique already), because Shopify requires that.
• Import Orders: match Capture transactions to Authorizations by Transaction: Authorization or Transaction: Parent ID column values, because Shopify requires that.
• Fix: Import Products: Metafields had error if importing Products with Metafields and specific variant positions.

---

2021

2021, December

2021-12-29

• Import Orders: give a warning if unable to restock Line Items when doing a refund with Refund: Restock as TRUE . E.g. when that item is not stocked in the specified (or default) location.
  To restock Line Items at a specific location, specify the location in column Refund: Restock Location.

2021-12-24

• Fix: Import Customers: sometimes when updating the Address, the Province was lost. While fixing this, we also made recognition of Countries and Provinces better.

2021-12-23

• Import: if the file has so many items that it exceeds “per file” limit, then give a warning about it when estimating (before pressing the Import), so that you can know in advance that the file will be cut off at the “per-file” limit.

2021-12-17

• Import Orders from WooCommerce: now taking also fulfillment tracking details from default WooCommerce tracking meta-data.
• Import Orders: improved searching Orders by Name, following the Shopify API changes.
• Export & Import Discounts: Buy X Get Y discount type now works whenCustomer buys is set to Minimum purchase amount.

2021-12-15

• Fix: UI: App was not loaded with styles on some browsers.
• Import Products from WooCommerce: mapped WooCommerce product statuses more precisely to Shopify Product Status.
• Fix: Import Products: protect if Shopify is returning all products in some cases when searching by Handle.

2021-12-14

• Fix: UI: if you deleted the FTP/SFTP server in Matrixify Settings, and then opened the previous job which was using that server, then the app UI crashed, and you had to reload the page.

2021-12-12

• Import from URL: assume that URL exists if it returns code 501 - Not Implemented.

2021-12-09

• Fix: Export & Import Products: Standard Type changes in Shopify API – export works now, but the import is not – waiting for an update in Shopify API. Currently – when we are setting this new field value, it’s being ignored. At the moment we will give you a warning when importing the Standard Type that this value might not be set – please, check it in your Admin.
• Fix: Import Files – support URLs with spaces.

2021-12-06

• UI: Better readable error and warning messages in jobs.

2021-12-05

• FTP: improved stability of uploading and downloading files – retrying on more network errors.

2021-12-04

• Import Orders: when importing from Google Sheets, remove the .0 from the Order Name if it is a number. Because, for example, if you write a value 1001 in Google Sheets, then it automatically gives it as 1001.0.
  So for Order Name it could mean that we didn’t find the Order with the correct name. Other way to avoid it is to set the column type to Text in Google Sheets.

2021-12-02

• Import Orders: optimized searching Orders by name – to be as quick as possible, but also in a more reliable way.
• Fix: UI: there were sometimes errors when moving Export columns.

2021-12-01

• Import from WooCommerce: the ability to specify the ?product_status= to migrate only products with specific statuses (can add several with a comma).

2021, November

2021-11-30

• Import: Products: ignore the Variant Image cell by setting the value [IGNORE] – this gives an effect as if there was no such column in the file for this row, so we will keep the existing Shopify value for that variant image.
  For example, if you don’t know the Variant Image for that specific variant, but want to add a new variant with its own variant image, and update other variant attributes at the same time.

2021-11-29

• Import: Metafields: allow metafield column names to be lowercase / not case sensitive.
• Export: Metafields: set to include only specific Metafield columns by new Shopify Metafield types.

2021-11-25

• Fix: Import Products: setting Variant Metafields when some of the deleted variants actually did not exist.

2021-11-23

• Import: Products and all other entities with Handle column: give warning if Shopify transliterated handle from international characters to English characters. This issue in Shopify Forums thread.

2021-11-22

• Fix: Export to Google Shopping: was too slow when not including Metafields.

2021-11-18

• Export: Google Shopping: dynamically adding columns of all Metafields in the mm-google-shopping namespace.
• Migrate Orders from Magento DB: taking Customer: Email, Customer: First Name, Customer: Last Name from order-level email field, and if there is no e-mail, taking them from billing address – to not attach Order to the billing-address customer, if this is a different Customer than the Order E-mail.
• Export: Orders: Fallback to UTM values from [order.referring_site] if [order.landing_site] has no UTM values.

2021-11-17

• Export Orders: Added Physical Location column, taken from [order.location_id].

2021-11-16

• Import Orders: finding Order by name with two methods – to decide which is more stable (Orders import by Name will be a bit slower for this week).
• Export & Import Product Standard Type: Product Taxonomy file updated.

2021-11-13

• Import from URL: follow the URL redirects which requires passing cookies from Set-Cookie header.
• Import from Microsoft SharePoint URL https://*.sharepoint.com – be able to download the file from it.

2021-11-12

• Fix: Import Products: was failing with [Metafield: Type cannot be blank] when adding Variants with Metafields.
• Import Orders: when searching by Name – if there are more than one Order found, then fail.

2021-11-11

• Fix: FTP – was not able to connect to server that returns error 502 for MLST/MLSD commands.

2021-11-10

• Fix: Import Metafields: no implicit conversion of Symbol into Integer.
• Giving warning after analyzing the file if there are Handles which contain non-English characters, which might get transliterated. You can switch off the transliteration in the Import Options – scroll down on the same page. Also, improved color-coding for errors and warnings, and showing separately for each sheet.

2021-11-09

• UI: Export: When selecting columns, do not automatically add any related columns – show them as suggested columns which you can accept.

2021-11-08

• Fix: Import: Metafields: Properly validating multiline json string Metafields.
• Security: enabled Permissions Policy for web browsers – to assure you that we will never request access to any peripherals or services like your GPS coordinates, speakers, etc. The only allowed browser permissions we keep is access to clipboard – to allow you copy/paste in the app.
• Import: should not assume as Files sheet if the file/sheet name contains [file] word (singular).

2021-11-05

• Export: Option to add apostrophe 'prefixes to values.
• Import: Option to remove apostrophe ' prefixes from values.

2021-11-04

• Fix: Export to non-Matrixify formats sometimes did not include all the columns.

2021-11-03

• Fix: Import: DraftOrders: should not index Draft Orders if the duplicate check is disabled (even if Name column is present in the file).
• Fix: Import Customers: set Address: Province when replacing the address, and not providing the Address: Province Code.
• Fix: Export Products: Standard Product Type was failing because Shopify changed their API. Please, restart any exports where you need Standard Product Type that have failed.
• Fix: Export: stop exporting when the plan limit is reached, instead of iterating through all items.

2021-11-01

• Export & Import: Files (those in Shopify Admin -> Settings -> Files). Read documentation.
• Import Orders: when searching by Name, try searching multiple times. Will make Orders import a bit slower, but a bit more reliable – to avoid duplicates.

2021, October

2021-10-27

• Fix: Import Products: Standard Type importing was failing if a product had images.
• UI: Settings: Additional explanation about Private Apps API call limit.
• UI: Jobs: show more precise % for API call increase, considering if this is a Plus or non-Plus store.

2021-10-25

• Import & Export Products: Standard Type columns – Type: Standard ID, Type: Standard Name and Type: Standard.

2021-10-21

• Import Orders from WooCommerce: add Fee lines as Line Items.

2021-10-20

• Fix: Import Products from Magento: Metafield columns got duplicated if the same fields were as custom columns and in additional attributes column.
• Fix: Import Products from Magento: should not generate Redirects for Products that don’t have a Handle.

2021-10-19

• Import: Orders: import tax from Order-level Tax columns if there are no Line Item Tax values, and auto-distribute the Tax across taxable line items.
• Import Orders from WooCommerce: added Order-level Tax.

2021-10-18

• Fix: SFTP: retry on a timeout of [execution expired] when determining an entry type (e.g. on CouchDrop SFTP).

2021-10-15

• FTP: retry to download or upload a file when getting EOFError – end of file reached.

2021-10-13

• Fix: Export & Import: e-mails about the started job were not sent.
• Fix: Export to UPS WorldShip: we did not include <VendorCollectIDNumberExempt> element in some cases when it was needed.
• Fix: FTP: improved work with FTP server types that don’t support MLST/MLSD.
• UI: Settings for Servers: tell that SFTP private key should be generated without a passphrase.

2021-10-12

• Fix: FTP – could not connect to a certain FTP server type – saying [500 'FEAT': command unrecognized].

2021-10-09

• We made a change that makes the connection to Shopify API faster and more stable, so jobs should be running slightly faster, and be less “stuck” than before.

2021-10-08

• Fix: UI: Export options time format dropdown was disabled for CSV if it was set to Excel friendly in Excel format.
• Fix: Export Products: plan limit was reached too soon when filtering by Metafields.
• Export to UPS WorldShip: Added <VendorCollectIDNumberExempt>=Y to <ShipmentInformation> to comply with new EU VAT regulation – for shipments to EU, GB, NO.
  To include the IOSS number in the XML file, please, sent it to our Support.

2021-10-07

• Import: Orders: Importing Email and Phone columns on Order level. Improved customer attach/detach logic for the Order.
• FTP: improved work with different FTP server types, e.g. couchdrop.io.

2021-10-06

• Fix: Charge: App was showing a blank screen after approving the app charge.
• Import Orders: guarantee that we will find existing Order by Name which has a space in it (workaround for Shopify API defect in their newest API version).

2021-10-05

• UI: Upgraded Shopify AppBridge to version 2.0.4.
• Fix: UI: show proper error if the specified URL is not valid – for uploading files, and for Export and Import options.
• Removed unnecessary Shopify API access scopes.
• Import: give more meaningful errors about missing or duplicate columns.
• Import: Magento Orders: convert HTML to plain text from history comments in Note field – to make it more readable.

2021, September

2021-09-29

• Fix: UI: sometimes the file was not downloading from the app – showing Forbidden, when files were private.

2021-09-24

• Fix: When selecting the “Schedule on” date on the computer where the time zone is ahead of the Shop time zone, could not select today’s date.

2021-09-22

• Fix: Import Products: image was not properly linked to Variant if image filename did not have a file extension.
• Fix: Export: Discounts – some items were failing when Prerequisite Subtotal Range was defined in Shopify API in an undocumented way.

2021-09-21

• UI: Show file copy icon as a lock if Public file downloads are not enabled.
• Return HTTP 403 if the file is not found or public downloads are not enabled.

2021-09-17

• Export & Import Draft Orders: New column Charge Taxes, to set the inverted tax_exempt field.
• Fix: Import Orders & Draft Orders: be able to match line items even if those have escaped HTML symbols like & or (.

2021-09-16

• Export: Metafields where namespace or key differs from other Metafield by just a special symbol or extra space are now exported as separate columns. Previously – they were treated as the same Metafield.

2021-09-11

• Export to CSV: if custom delimiter, newline or quote is empty, then reset to default.
  If need to have no quote symbol, then in Options deselect the “Force quotes” checkbox – then there will be no quote symbol (unless the value contains the delimiter, then it will be put in quotes, otherwise it would offset the columns with extra delimiter).

2021-09-09

• Fix: Export Orders: sometimes got the invalid byte sequence error when including Browser columns with UTM tags.
• Export Orders: added separate columns for [Phone] and [Email] (because they are different from [Customer: *] columns).

2021-09-08

• Fix: allow export custom file name to include square brackets [ and ].

2021-09-06

• UI: Show date attributes for Jobs more logically.

2021-09-04

• UI: All Jobs – improved loading speed and filtering of all jobs.

2021, August

2021-08-30

• Fix: UI: Export on Safari: selecting an entity app moved the selected entity to the end of the entities list, but now it stays at the same place on the screen.
• Fix: Import Products: HS codes could not be imported for some stores because of differences in versions of Shopify stores.

2021-08-28

• Fix: Import Products: Variant HS Code can now have any additional symbols, keep only digits.

2021-08-27

• Fix: UI: filter calendar week to start with Monday (to be consistent with Shopify Admin).
• Fix: UI: All Jobs filter by date range to include also jobs from the last day.
• Fix: UI: When canceling a scheduled future job, make it not appear on top of all other jobs anymore, but show sorted by the date when it was canceled.

2021-08-19

• Export: Google Shopping Data Feed: Added columns unit_pricing_measure and unit_pricing_base_measure.

2021-08-18

• Fix: Exporting to Custom File Name that includes : returned an error for the export job. Now will get converted to - as other special characters.

2021-08-15

• Migrations: improved that import from Dry Run results file or no-Dry Run (direct import from another system) produces the same result in Shopify after importing.

2021-08-14

• As we are rebranding to Matrixify, we have changed the app URL from https://app.excelify.io to https://app.matrixify.app.
  It also means that the file download URLs have changed respectively.
  All the previous file download URLs will continue working, so you shouldn’t feel any changes.
• Download files much faster by redirecting to temporary download URL directly on S3 (HTTP 307).
  If you have some scripts that cannot follow HTTP redirects, then please ask our Support – we will enable downloads for your shop without redirecting. But now downloads will be 50x faster than before.
• Export: new Option – Prefix phone numbers with apostrophe ' (more Excel-friendly) – so that you can switch it off.

2021-08-09

• Migrate from WooCommerce: recognize also weight unit lbs (plural).
• Fix: Migrate Orders from WooCommerce: take into account if the tax is included in Line Item price when calculating Line Item price for Shopify.

2021-08-07

• Import from URL: stop the repeated job chain if the source file was permanently deleted – with HTTP 410 status (typically deleted Google Sheet).

2021-08-05

• Fix: Import from Google Sheets: Some Google Sheet links were returning an error URL does not exist. Changed URL app uses to download Google Sheets Excel file.

2021-08-03

• Fix: Migrate from WooCommerce: ignore pa_option metafields to make fewer Metafields.
• Export & Import: Metafield new type boolean.
• Import: improve file upload speed and stability.

2021, July

2021-07-31

• Fix: Showing proper error message if the downloaded file is empty.

2021-07-30

• Import & Export: Products: Ability to import and export Variant Province of Origin column.

2021-07-28

• Import: Handling empty values in numeric cells in Excel files and passing excel parsing errors to the user

2021-07-25

• Fix: Import: WooCommerce Products: Only importing trash products if they are supported by the server and ignoring the otherwise.

2021-07-24

• Import: WooCommerce Products: Importing trash products from WooCommerce as Archived in Shopify.

2021-07-23

• Import: WooCommerce Products: Save Product dimensions into product and variant metafields.

2021-07-22

• Import: Magento Orders: Saving store_id into order metafield Metafield: magento.store_id [integer].

2021-07-18

• Import: Shop: detect as the Shop sheet if has the shop word in the sheet name, and no other words (can have other numbers or special symbols in the sheet name).

2021-07-16

• Allow creating 10 jobs per minute, separately for batch and non-batch jobs.
• Fix: Import – retry if getting error 520 from Shopify which means “Unknown Error”.

2021-07-07

• Fix: Migrating files to new storage – Downloading file from a link without job id parameter was downloading an old migrated file which was considered the newest file.
• Import: Products: match Variant Option columns more precisely, and ignore if they have any extra words.
• Import: Allow importing files with non UTF-8 characters in the file name.

2021-07-06

• WordPress Migration: improved stability to download images.
• UI: Pause the job progress refreshes after 10 minutes of inactivity – saves your network traffic. Resume when moved the mouse.

2021-07-05

• Fix: Import Products: improved variant sorting by positions when adding new variants or updating existing variants to an existing product.
• Fix: File uploads longer than 1 minute were failing with internal server error.
• Fix: Import: Understand the date fields where time is one number without leading 0, like 9:45:40.

2021-07-04

• Fix: It was not possible to re-install the app if it was uninstalled earlier.

2021-07-03

• UI: app is no longer using 3rd party cookies; now you can use Matrixify app on several stores at the same time in the same browser (separate tabs).

2021-07-02

• Export Orders: do not export Discount Line with duplicate script discount which is already on Line Item level.
• Export Filters: check that the filter condition contains all of matches in the whole list, not just in a single element.
• Export Filters: validate date to be in a normal human date range.
• Fix: Import Products: Variant Metafields failed with an error if there are more than 1000 Variant Metafields to update.

2021-07-01

• Import: fail if importing Shopify Admin exported Orders or Draft Orders because those files lack significant details. Use Matrixify exported format instead.

2021, June

2021-06-30

• Import: Show warning if Command DELETE or REPLACE is being used – to bring attention that this will delete those existing items.

2021-06-29

• Import: Imports in general made faster, to utilize Shopify API call limits smarter.
• Import: Discounts: import speed optimized by making fewer API calls.

2021-06-28

• Import: Orders: do not retry creating new Order if Shopify API is responding with error 5xx – to avoid creating duplicate.

2021-06-27

• Import from ZIP: Detecting encoding for each CSV sheet instead of once per import.

2021-06-22

• Import from URL: when importing from a URL that does not return importable data assume the file is Unknown and be clear that we cannot import that.
• Import: Products: be able to import Variants with each having 1000+ Variant Metafields.
• Import: show more understandable [From URL] names for repeated imports from Google Sheets, Google Drive, Dropbox, and Matrixify links.

2021-06-16

• Import: Products: Improve update speed by not reading inventory levels when it’s not needed to be updated.

2021-06-15

• Import & Export: Orders: new column Refund: Generate Transaction – TRUE generate refund transactions even if there are no Transaction data linked to the refund in the file; exported as FALSE, import default TRUE.
• Fix: Job Scheduling: for jobs with repeating intervals over 1 month it was sometimes fluctuating by 1 day because of daylight saving.
• Fix: Export: Orders – was failing if there was an empty response with transactions from Shopify.
• Fix: Import Metafields: if Command was NEW, but the item already existed, it still updated the Metafields of the existing item, but now it will not anymore.

2021-06-12

• Fix: Import from Turn14 was failing.

2021-06-09

• Import: Discounts: Optimize speed by not searching related items which are already found, and failing faster if something is missing.

2021-06-08

• Import: Do not retry if getting HTTP 502 error from Shopify when creating new items – to avoid duplicates.
• Fix: Export Filter by Metafields: was not working if Metafield namespace or key were not in lowercase.
• Import from Google Sheets: retry downloading the file up to 10 times if any cell in the first 2 rows has value [Loading...] – to avoid the Google Sheets defect that it is giving the file before completing formula refresh.

2021-06-07

• Import: when specifying the wrong value for Inventory Available: ... column – then show that column in the UI errors during the import.
• UI: Allow to upload only files with acceptable extensions – xlsx, zip, csv, txt, json.

2021-06-04

• Update app to Shopify API version 2021-04.
• Export Options: Time format Option to choose Time format for all date & time columns.

2021-06-02

• Export: Include entity name in the exported file name if exporting a single entity with unzipped Matrixify: CSV format.

2021-06-01

• Fix: Import: Products: Was failing when option value ends or starts with space.
• Fix: Import from URL: Importing with escaped characters made more reliable.
• Fix: File upload: Take file name from path only if the path exists.

2021, May

2021-05-28

• Fix: When exporting or importing files of the same name – the ability to download that specific file version that was exported or imported for that specific job. (For jobs that are created after 2021-05-28 11:00 UTC).

2021-05-26

• UI: Rearranged Import Options more logically.

2021-05-25

• Notification e-mail changed from [email protected] to [email protected].

2021-05-24

• Import: BigCommerce API: migrate BigCommerce Brand field as Vendor in Shopify.

2021-05-21

• Export: unified all date column formats to be ISO standard. Option to export date as Excel friendly – for reports and local regional formatting.

2021-05-19

• Fix: Importing CSV file with Results file set to Excel – cut the sheet/tab name to 31 characters, to fit in Excel sheet/tab name limit.
• Fix: When the sponsor shop changed the plan after 30 days, the sponsored shops got detached automatically but had to stay attached.

2021-05-17

• Import Options: Ability to specify the Result file type – Default, CSV or Excel.

2021-05-16

• Fix: Import: limit Import Result column length to 1000 characters – to not overwhelm storage if having long errors.

2021-05-15

• Import from CSV: use UTF-8 encoding when importing from unsupported encoding.

2021-05-11

• Import: Products: Improved flexibility when updating/deleting product options.

2021-05-09

• Import from WooCommerce: If not able to read a Product from the WooCommerce API, the app will create a placeholder row for that product with the WooCommerce ID and fail that row. If such a Product is in an Order, then that Order will receive a warning that app could not read the product to get line item details.

2021-05-07

• Import Orders: for Refunds without Transactions – check if Line: Price matches the actual line item price, to avoid accidental full refund when need to have a partial refund.

2021-05-06

• Orders: Rename column Line: Gift Card Send to Customer to Line: Force Gift Card.

2021, April

2021-04-30

• Import from Turn14: Set the Variant Cost value from purchase_cost. Due to how the Variant Cost is saved in Shopify API, this will could make imports from Turn14 longer.
• Fix: Import Orders: Incorrect value in theLine: Gift Card Send to Customer column failed order with uninitialized constant ... error.

2021-04-29

• Fix: Import: UI was not showing correctly Started At date for the automated jobs that had longer estimates.
• Security: Send an e-mail notification to store Owner if changing Matrixify Security Settings.
• Fix: Export Metafields: Different Metafields were written in the same column if both of them returned the same column header when normalized (without special characters and spaces).
• Fix: UI Filters were not available for about an hour.
• Import Orders: optimized Transactions import, also can import authorization transactions for existing Order

2021-04-27

• Fix: Import Customers: Importing Multipass Identifier column empty will set it in Shopify to a proper empty value – null, not to an empty string "".

2021-04-23

• Fix: Export Products: Receiving Shopify error undefined method `[]' for nil:NilClass when getting Product Status via GraphQL.

2021-04-21

• UI: Pricing removed Image Server – due to the low popularity of the feature, it is being removed from the offered services for the Enterprise plan. You can still easily create your own Amazon S3 bucket for image file hosting.
• Fix: Import from WooCommerce: the ability to process the WooCommerce API response of 101-level-deep [[[…]]] nested JSON array.
• Import: BigCommerce API: Migrate Google Shopping Metafields for Products.

2021-04-19

• Export: when no items are exported, show Exported: 0 – otherwise, users were thinking that the total count is the exported count.
• Fix: Export Orders: plan limit was reached when filtering export even if no items were exported.
• Fix: WooCommerce API: When migrating to Shopify, ignore sort_cat_ Product metafields because they generate a lot of unnecessary metafields in Shopify.

2021-04-16

• Export: Status field was exporting empty for some Products due to exporting from Shopify REST API. Now taking Status from GraphQL API if it’s empty – should be exported for all Products.

2021-04-15

• Import: Orders: added safety mechanism when importing Transactions – set the imported gateway only if column [Transaction: Force Gateway] is TRUE. Otherwise custom Gateway will be set to ensure that no real money transactions are created. This currently does not affect refund and capture transaction imports and is intended for migrated Order sale and authorization transactions to be imported without a real gateway.

2021-04-12

• Export: removed Amazon Inventory Flat File from export format dropdown. Change is done based on this not being a popular feature, the complexity of exporting to Amazon format, and multiple merchant complaints about not being able to make it work in Amazon as the process is complicated. If you still wish to use this feature, you can find an export job you have done previously to Amazon Inventory Flat File and click “Export Again” button.
• UI: Ability to detach the linked My Other Shop. After 30 days have passed since the stores were linked, you can go into app settings and detach the stores yourself.
• Import Orders: Amazon FBA: if Amazon gives empty Customer data, then fill in the Last Name from Email and Address1 as REDACTED.

2021-04-09

• Export Summary: Added columns: Job ID, Started At, Finished At, Duration, Seconds per Item to see more details about the export job in the exported file.

2021-04-08

• Export: Clicking the Export Again button will not copy Schedule on date in the new export page to ensure that export is not scheduled in the past. If you require to copy a job scheduled at a specific time, you need to again select the Schedule on option in the export options.
• Fix: Import from BigCommerce CSV: was failing if there was an empty collection.

2021-04-06

• Fix: Import Orders: correctly getting fulfillment service from linked variant to check if the product is a Gift Card. If Product that is linked to the Line Item is Gift Card but the file says not to create a Gift Card then Line Item will not be linked to the Product to ensure that Shopify does not automatically issue a Gift Card.
• Fix: Import Orders: for PayFlow transactions assuming manual gateway because PayFlow sometimes sends out the real refunds for fake transactions.

2021-04-02

• Fix: Import Products: Creating a new product with custom fulfillment was failing due to how Shopify handles inventory locations for custom fulfillments.
• Fix: Import / Export Metafields: If Metafields namespace or key includes dot . then escape it with a backslash \ so it can be properly detected and imported. For example, in the column header Metafield: my\.items.specs the namespace will be imported as my.items and key will be specs.
  Make sure to check if your automated imports do not have an additional dot in the Metafields column header, if it does then adjust the import and escape the additional dot with backslash.
  The same applies for exports – if you are processing exported file which contains Metafields then adjust your system for it to understand escaped dot in namespace or key if you have any.

2021-04-01

• Fix: Export Orders: Do not allow to enter text for the Line: Quantity filter.
• Fix: Export Orders: Rows with the same data were exported as the same row, e.g. if two line items are the same product and variant.

2021, March

2021-03-30

• Fix: Export: Repeated exports with relative time filter were filtering from jobs scheduled time not taking a full hour.

2021-03-27

• Fix: Scheduled Import & Export: Improved repeated jobs by considering the daylight savings time (DST) shifts. If the job has been scheduled at a specific time, then it should run at the same local time after the DST shift, if the job has been only set as repeated then it will run by UTC time ignoring DST shifts.

2021-03-24

• Fix: Sometimes an e-mail notification was sent that job failed with no error when the job was running seemingly correctly.
• Fix: FTP: upload file without the .filepart if cannot delete the existing file, try to overwrite it directly.

2021-03-23

• Fix: Upload to FTP: retrying to rename .filepart file to the final file name if the file is still present.

2021-03-20

• Fix: Import Products: swapping variant images to featured image sometimes did not work.
• Import from WordPress AllExport: Take content and dates from WordPress API to have accurate front-end HTML code.

2021-03-17

• Export Orders: Added new columns: “Price: Total Refund“, “Price: Current Total“.

2021-03-16

• Fix: Import Products: swapping variant images to featured image sometimes did not work.

2021-03-15

• Export: Orders Filter: Fulfillment Status filter unified with Admin UI filter, when exporting Unfulfilled Orders.

2021-03-12

• Fix: Upload to FTP: give error if cannot rename uploaded .filepart file – so that you can contact Support with such server details.
• Fix: Import from WordPress: properly detect the dates for AllImport format.

2021-03-11

• Fix: Import Discounts: do not retry creating Discount Code if it already exists for Price Rule.
• Fix: Import from FTP/SFTP: adding / to path prefix if not specified.

2021-03-10

• Fix: Import from FTP/SFTP: moving files that have dynamic placeholders sometimes did not find the file.
• Export: Orders: include customer data only in first row for specific store (ask Support if you need it too).
• Fix: WooCommerce API: Calculate Order tax rate even if tax has been deleted in WooCommerce store.

2021-03-08

• Import: ignore extra surrounding spaces for Title value for Products, Collections, Pages, Blog Posts.

2021-03-06

• Fix: Proper error when “Line: Discount” is not a valid number.
• Fix: Import from WordPress / WooCommerce: limit generated variants to 10,000.

2021-03-04

• Fix: Export: Orders: when exporting with Refunds and Transactions – the same transaction was appearing 2 times.
• Fix: Import: Orders: do not create refund if the refund transaction was with “failed” status.
• Export: Orders: improved speed when exporting without “Line: Variant Inventory Qty” column.

2021, February

2021-02-26

• Export: Orders & Draft Orders: include values in all rows for “Customer: ...“, “Billing: ...” and “Shipping: ...” columns.

2021-02-24

• Import: when deleting items, check if it is actually deleted in Shopify. Fail if Shopify is not eventually deleting it after retrying 50 times. Deleting will be slightly slower, but you will be sure it actually deleted those items.
• Fix: Import Batch: for repeated/scheduled Batch job was sending notification as for manual import.

2021-02-23

• Fix: Import from FTP: support the username that contains /. Like: ftp://subdomain/[email protected]@subdomain.server.com/path/to/file.xlsx.

2021-02-20

• Fix: importing CSV files from FTP/SFTP with the dynamic file name, and moving them in folders was failing, or importing two files.

2021-02-19

• Import: ability to cancel when uploading large files.
• SFTP: make file downloading and uploading more robust and stable.
• Import from FTP/SFTP: limit uploaded file size to 2 GB.

2021-02-18

• Import: improved work with file names that have spaces and other symbols.

2021-02-17

• Import from CSV: for files encoded in UTF-8 encoding, remove any non-UTF-8 encoded characters, or invalid byte sequences.
• Import from WooCommerce: added support for additional payment gateways: woo_braintree_payment_gateway, yith-stripe, yith-stripe-connect, yith-paypal-ec, paypal_express, amazon_payments_advanced.
• Fix: Import from WooCommerce: fill the “Refund: Created At” for refunds and their transactions.

2021-02-13

• Import Products: when identifying by [Variant SKU] – put the found products at first, and only then rows of missing products.
• Import from Google Sheets: allow importing from a direct link to Sheet as CSV file.

2021-02-12

• Import from BigCommerce: equally spread the available product level quantity among generated variants.
• Fix: Import from FTP/SFTP: file action to delete or move was not done if file name contained a space.
• Import Orders from Amazon FBA: made the Shopify Total to match the Paid Amount, even if there is a discrepancy in Amazon/Shopify total amount.

2021-02-11

• Export: Customers: filter by [Accepts Marketing] field.

2021-02-10

• Fix: FTP: ensure that when retrying to connect, the previous connection is closed; detect permission error and do not retry on that.
• Fix: Import: Orders: cancelled Fulfillments sometimes could not be created – it was telling that cannot overfill the fulfilled Order.

2021-02-08

• Import: Orders: ignore Fulfillment Lines which have [Line: Quantity] of 0.
• Import: Products: improved warning messages when updating variants.

2021-02-07

• Fix: Export Products: the Status value was not included when filtering by Collection.
• Fix: SFTP: retry if uploading or downloading file is stuck longer than 1 hour.
• Fix: Import Orders from WooCommerce: setting negative “Line: Quantity” for Refund Line, and filling correct “Refund: Created At“.

2021-02-06

• Fix: Import from FTP/SFTP: file actions (Delete and Move) now work when importing from URL with dynamic placeholders.

2021-02-05

• Import: WooCommerce API: Fail individual items where cannot get notes or refunds from WooCommerce.
• Export Orders: fail the whole job if lacking any permissions to related items in the Private App.
• Fix: Import Products from BigCommerce API: use pre-calculated price adjustment for non-modifier variants; use Compare At Price from Retail Price.

2021-02-03

• Import Products: More informative warnings when unable to update variants.

2021-02-02

• Import: show Import Comment in the Result file telling which entity was not found.
• Export to CSV: Specify custom delimiter, quote, newline, and encoding.

2021-02-01

• Fix: Export Discounts: should not fail if cannot get count of Discounts in the store, but still try to export them.

2021, January

2021-01-28

• Import Products from LightSpeed: prefer English language values when file has multiple languages.
• Settings: [Allow downloading your files by external services] is off by default for newly installed shops.
• Import Orders from Magento DB zip file format: significant speed improvement – from 5+ sec/item to 0.07 sec/item.

2021-01-27

• Fix: Import: Command UPDATE was not allowing to update some items by ID when updating basic fields.

2021-01-26

• Export: Orders & Draft Orders: include all taxes for Line Items (not just first 3).

2021-01-25

• Fix: Export Draft Orders & Activity: Status filter got ignored for exports.

2021-01-24

• Import from WooCommerce: new payment gateway [Credit Card / braintree_credit_card].

2021-01-23

• Upgraded to newest Shopify API and Polaris platform versions.

2021-01-22

• Export: if the store has more than 10 Blogs, then not showing the count of Blog Posts – because it takes too long to count them.
• Fix: Export Orders: [Refund: Restock] column was always TRUE, regardless of the real value in Shopify.

2021-01-20

• Fix: Import Products from BigCommerce API: Take the largest-size images instead of the standard-size images.
• Fix: Import Products: Should not transliterate the Custom Collection handles if the Option asks to not transliterate handles.
• Fix: Import Orders from WooCommerce API: improved Line Item amount and Order Total calculations – considering Tax and Discounts (with/without taxes).

2021-01-19

• Fix: Import from BigCommerce API with auto-repeated job was failing on the 2nd time.

2021-01-18

• Import: changing Command UPDATE to strict – fail if item does not exist. To create or update – use Command MERGE.

2021-01-17

• Fix: Import from WooCommerce: show progress when loading products in Demo plan – do not make impression that it is stuck.

2021-01-15

• Fix: Import Orders: make sure Gift Card is not auto-fulfilled by Shopify if Product itself is a Gift Card, when [Line: Gift Card Send to Customer] is NO.

2021-01-14

• Import from WooCommerce: added payment gateways – Bogus, Shopify Payments, Credit Card with Authorize.net.

2021-01-12

• Migrate from BigCommerce, WordPress and WooCommerce: download and convert also responsive images in img srcset attribute.

2021-01-11

• Import Products: Ignore the “Ignore ID” option if identifying Products by Variant SKU, because we need to use the found ID for each SKU.
• UI: Removed Google Analytics tracking form the App.

2021-01-09

• UI: Ability to close notifications on App page.

2021-01-07

• Fix: Import Orders: workaround of Shopify bug that creating an Order causes Customer to not accept marketing.

2021-01-05

• Export to UPS WorldShip and Wurth IT: Removed GB from EU countries – due to Brexit.

2021-01-04

• Migrate from WooCommerce: generate variants from variation attributes too.
• Export to UPS WorldShip: switched off special COVID-19 VAT which ended on Jan 1st, 2021.
• Import Blog Posts: changed default “Comment: Command” to “MERGE“.

---

2020

2020, December

2020-12-31

• Import Products: following image redirects to improve linking images to variants.

2020-12-30

• Import Products from Magento: parse custom options that have | in their title; import column variant_inventory_policy from Magento file.

2020-12-23

• Import: new Commands – MERGE, IGNORE. Warning if using UPDATE instead of MERGE, because UPDATE will become strict.

2020-12-22

• Export: Filter all the entities by Metafield value (Products, Collections, Customers, Orders, etc.).
• Import Orders: ignore transactions with 0 amount (except for void transactions).

2020-12-21

• Import from FTP: support the AS400 system based FTP server.

2020-12-18

• Import from WooCommerce: detect the weight unit even if Settings API is not available.

2020-12-17

• Import Orders from Amazon FBA: generate also transactions for all the imported Orders to show that the Customer has paid that Order in full amount.
• Fix: Import Products: Sometimes still was getting the “Compare at price needs to be higher than Price” error when Product Price is not smaller than Compare At Price.

2020-12-15

• Import Metafields: column name Metafield prefix and the type need not be case-sensitive.
• Import Orders: read Transaction columns for any line type – so that can import Line Item and Transaction from the same row.

2020-12-11

• Export Orders Filter: added “equals to all of” and “contains all of” conditions.

2020-12-10

• Export Orders: include also Discounts with “automatic” and “script” types; and show the Percentage value in “Line: Price” column.
• Export Filters: multiple choices for Products -> Status; Draft Orders -> Status; Orders -> Status, Payment Status, Fulfillment Status; Activity -> Subject Type.

2020-12-06

• Import Orders: import Gift Cards as Custom Line Items to make sure Shopify does not auto-fulfill them (as an unexpected surprise for your clients from 6 years ago). Change that by setting the column [Line: Gift Card Send to Customer] – to get the real Gift Card fulfillment.

2020-12-05

• Fix: Export Collections: exporting some column combination returned rows without Linked Products columns.

2020-12-03

• Import Products: when identifying by Variant SKU, then put current Shopify product Handle value in new “Handle (Ref)” column to ignore it for imports – as it’s just for reference to see what product it is that’s updated by SKU.

2020-12-02

• Fix: Import Products: improved workaround to allow setting Variant Price larger than Variant Compare At Price if only importing one of those columns (not both).
• Export Orders: Filter option to “Include only matching Line Items” that match applied Line Item filters (Line: Variant Inventory Qty, Line: Vendor, Line: Product Handle, Line: SKU).

2020-12-01

• Export to CSV: when unselecting the Excel-friendly format option, then do not include BOM and do not put quotes around all fields – to make CSV files more compatible for automation.

2020, November

2020-11-30

• Import Products: Command for strict update UPDATE_STRICT – to only update the product if it exists, and Fail if it does not exist. This is a temporary command for the strict update because we are gradually transitioning to swap the commands – MERGE will create or update if exists; UPDATE will be strict in the future – we will keep you updated on the transition schedule.

2020-11-28

• Export Draft Orders: added filters – by ID and by Tags.

2020-11-27

• FTP/SFTP: write to temporary .filepart file at first, and then rename to the real file name – only when the file is copied. To avoid automation scripts reading the file before it is finished uploading.
• Export Draft Orders: new columns: “Invoice URL” and “Invoice Sent At“.

2020-11-26

• Export: Filter Orders by Metafield value.

2020-11-25

• Export to CSV: new option to encode the CSV file for Excel (with BOM) or for automation (without BOM).
• Import: Products – workaround to allow Variant Compare At Price not to be higher than Variant Price (fixing the [Compare at price needs to be higher than Price] Shopify API requirement).

2020-11-21

• Fix: Import from SFTP – error “false can't be coerced into Integer“.

2020-11-19

• Import: WordPress with AllExport format: fix the featured image link if it is with newline and tab symbol in it.
• Fix: Import Metafields – getting the “Key: must be unique within this namespace on this resource” error if Metafield key has language-specific special characters.
• Export: Orders – filter by [Line: Variant Inventory Qty] of the linked Product.

2020-11-16

• Import: BigCommerce – Products and Categories with all the needed details from API (ask Support for instructions while we are working on the Tutorial).

2020-11-13

• Import: Products – when importing “Variant Compare At Price” as 0 then set it to empty (to comply with new Shopify API requirements).
• SFTP: Export to SFTP using Private Key authentication. Upload Import Results to SFTP using PK, too.
• Export & Import: Product Status column; also filter export by Status.

2020-11-12

• Import: Products – “Image Position” now indicates the place from the top, meaning that if another image already exists on that Position, then it is moved down.
• Import: allow to import also from Google Sheet “Publish to Web” link as CSV or Excel file.

2020-11-10

• Export: UPS WorldShip – automatically exclude any Orders which do not have any fulfillable Line Items in them.

2020-11-09

• Fix: Import: Orders – when Fulfillment columns are filled for the same Line Item row, fulfill only Line Items that have Fulfillment columns filled.
• Fix: Import: Orders – generate Fulfillments also for Gift Cards because Shopify did this automatically earlier, but stopped doing.

2020-11-04

• Import: Option to not check if items already exist in Shopify – to increase import speed. Enabled only for specific stores when asked Matrixify Support.

2020-11-03

• Fix: Export Orders – Additional Details was not escaping the : symbol in the name, and therefore it was failing in the imports.

2020-11-02

• Fix: Import Product – adding Variant with image was not setting that image for the new variant.
• Fix UI: Export – switching Simple/Advanced tabs on Safari was jumping on Safari.
• Fix: Import Redirects – had an error “Failed. Path: has already been taken” if there was a / at the end of the Path value because it didn’t find an existing redirect.
• Fix UI: Dropdown in Export Advanced tab was closing after changing each checkbox.

2020, October

2020-10-30

• Fix: Import from WooCommerce API – converting Product “lbs” weight unit to “lb”, and retrying if WooCommerce API responds with an error.
• FTP/SFTP: Improved connection stability and retry mechanism when connecting, sending, or reading files.

2020-10-29

• Fix: Import from WooCommerce API – was failing if there are too many Metafields which start with digits.
• Fix: Export Orders – Fulfillment Line Discount to be a negative number, and Total to be respectively Price minus Discount.

2020-10-24

• Import: WordPress – allow to import from WooCommerce API which is under a path (subdirectory).

2020-10-23

• Fix: UI: Import from Magento – was not showing the “Old server URL” input box.

2020-10-21

• SFTP: Import – choose to authenticate using the Private Key instead of the password.
• SFTP & FTP: Do not show passwords on UI.

2020-10-20

• Fix: Export to eBay format – was failing if could not find variants for a Product (if the Product was deleted while export is in progress).

2020-10-19

• Import: Skip empty lines, and stop reading the file if there are more than 100 consecutive empty lines.

2020-10-14

• Fix: Export Activity – allow filtering by Created At with larger timeframes, that previously failed due to Shopify API limitation.

2020-10-08

• Export: Google Shopping – limiting “additional_image_link” column to 10 images or 2000 characters to comply with Google Shopping requirements.

2020-10-06

• Import: Orders from Magento – improve Dry Run speed by automatically switching to CSV format for larger files.

2020-10-05

• Fix: Import: Orders – match Line Items in Refunds and Fulfillments also by Variant Title.
• Fix: Import: Orders – whole Shipping Address was empty if “Shipping: Country Code” was empty.

2020-10-01

• Import: Custom Collections – “Product: Command” column to allow MERGE, DELETE, REPLACE products in Collection.

2020, September

2020-09-25

• Fix: Import – Magento Orders: fulfill Simple item if a Configurable parent item is fulfilled; Generate Shipping Line even if Shipping Price is 0.

2020-09-22

• Export: Customers – “Multipass Identifier” column with values from Shopify.

2020-09-21

• Import: Fail and do not retry if Shopify API responded with an error when creating a new item – to avoid creating duplicates.

2020-09-19

• Fix: There was a “Not Found” error when replacing a Collection with Metafields. Also, made replacing items with Metafields a bit faster.

2020-09-18

• Export: fail if exporting to Excel with more than 10,000 columns (due to many Metafields), and suggest to use CSV format.

2020-09-17

• Fix: Export Orders – fill data for columns “Refund: Restock Type” and “Refund: Restock Location” when exporting Refunds without Line Items.

2020-09-14

• Fix: Export – Activity: sometimes failed when filtering by Created At, because of the Shopify API issue.

2020-09-09

• Import: WooCommerce Products and Orders – Metafields that end with a number like wt_awarded_nth_coupon_78567, save as two Metafield columns: Metafield: woo.wt_awarded_nth_coupon_id and Metafield: woo.wt_awarded_nth_coupon, to avoid generating thousands of Metafield columns.
• Fix: Import: Magento – sometimes the import job got frozen when canceling while indexing the files.

2020-09-08

• Fix: Import from Google Sheets – Phone sometimes got added 0 to the end because of formatting.

2020-09-04

• Fix: Allow using Matrixify on linked store if Sponsor store has been closed/uninstalled.
• Fix: SFTP – connecting to SFTP servers which require different/less known encryption methods.

2020-09-03

• Fix: Import – auto-retry if Shopify API responds with unknown error “Failed. Base: Internal error” when creating or saving an item.
• Fix: Import BlogPosts and Pages from WordPress – downloading images with non-ASCII symbols: “URI::InvalidURIError - URI must be ascii only“.

2020-09-02

• Fix: Was not able to change the paid Plan – due to sudden Shopify API changes.

2020-09-01

• Fix: Import from SFTP was not working if the password contains a special symbol.

2020, August

2020-08-31

• Export: when having repeated job with Relative Time filter, then do not jump over the time intervals even if the job takes longer than the interval itself.
• Export: if the scheduled job with Relative Time filter will start a few seconds/minutes after the scheduled time, it will still apply the Relative Filter from the time it was supposed to be actually started.

2020-08-28

• Export: Format all price and amount columns as 0.00 in CSV.

2020-08-26

• Export: Format all price and amount columns as 0.00 in Excel (with two decimal places).

2020-08-24

• Fix: Import – Products: weight gets re-calculated from grams if not even updating the weight, making it change a bit.

2020-08-22

• Fix: Import – retry when saving an item and getting an error [Failed.] from Shopify API without an explanation.
• Fix: Import from WooCommerce – when results file is saved to CSV, then save each sheet in its own CSV file.
• Import: WooCommerce Orders – allow to filter with ?only=orders&since=2020-01-01T00:00:00 to get only Orders since a specific time.

2020-08-21

• Import: Orders – fail if adding the Line Item which is linked to the same Product Variant as existing Line Item.

2020-08-20

• Fix: Export – include several namespaces as comma-separated values.

2020-08-17

• Allow opening the Matrixify app with the non-Admin user even if new API permission scopes are required.
• Fix: Import Orders from WooCommerce – do not fail if Stripe payments don’t have an amount data found.

2020-08-16

• Import: Orders – Add line Items to an existing Order (without the need to replace it) – by using the “Line: Command” = “MERGE”.
• Import: Orders – Command “MERGE” to create an Order or update if already exists.

2020-08-15

• Fix: Import from WooCommerce – avoid collisions when generating Metafield column names. JSON Metafield values as correct JSON strings.

2020-08-12

• FTP: connecting to server even if it returns wrong IP for the Passive Mode.

2020-08-07

• Fix: Could not re-install the app after it was uninstalled.

2020-08-05

• Import: Orders from WooCommerce – using full order amount for transaction amount if the Order is fully paid, and has an unsupported payment method.
• Fix: Import: Products from Turn14.com – take the Title also from product_name if part_description is empty.

2020-08-04

• Fix: Import: Products – “Weight Value: is not a number” when weight is empty. This is a new validation on the Shopify API side.
• Import: migrate Products from BigCommerce format (and generate their Redirects).

2020-08-03

• Fix: Cannot use the app if any of the past Jobs got the Plan as “Uninstalled” because the scheduled job started on the shop which was uninstalled.

2020, July

2020-07-30

• E-mails: guaranteed to send an e-mail even if new app version was deployed while job is running.
• Fix: error when importing Orders with Fulfillment: Shipment Status as DELIVERED in all caps.

2020-07-28

• Import: Products – remove surrounding spaces from all fields.

2020-07-27

• Reduced Shopify API call count to make imports and exports faster, and improve overall app speed.

2020-07-24

• Import: WooCommerce / API: WorldPay payment gateway.

2020-07-21

• Fix: Export & Import: zip files in such a way that files over 4 GB can be unzipped normally.

2020-07-18

• Migrated to new infrastructure to make Matrixify a faster and more scalable.

2020-07-17

• Import: WooCommerce Orders – remove HTML code from Notes.
• UI: Show the time zone when hovering on the Job time – the time zone in Matrixify UI is always what your Shopify Admin has in its Settings.

2020-07-16

• UI: When clicking on “You have n scheduled jobs” – apply filter to show only Scheduled Jobs.

2020-07-15

• Import – Orders: include Shipping Line taxes in the Total Tax.

2020-07-14

• Import – Custom Collections: if Shopify gives an error on adding products to a huge Custom Collection, retrying in smaller batches down to 1 product.
• FTP: retry 10 times if uploading a file and getting a Timeout error.

2020-07-09

• Import – Orders: allow to update Shipping Address fields to empty, if there are some values set earlier.
• Fix: Import – Orders: when cancelling Order without refunding, void the authorization transaction only if Order has no capture/sale transactions, otherwise Shopify will automatically refund it.

2020-07-07

• Fix: Import – Draft Orders: retrying when getting the “Unprocessable Entity. This order has not finished calculating, please try again later” from Shopify.

2020-07-04

• Fix: Export: sometimes getting an error “undefined method `path' for nil:NilClass” when exporting Orders related data. If this repeats, let us know.

2020-07-03

• Fix: Import: Correctly detecting if the SFTP link is a file or directory – on some server types it is even more different.

2020-07-02

• Email: reduced App notification e-mail size from 350 KB to 22 KB. Showing good on Gmail now too.
• Import: if importing Excel sheet larger than 500,000 rows then generating results file as CSV to make it faster.

2020-07-01

• Import: from Bespoke Factory – setting Tags Command to MERGE.
• Import: Migrate Orders from WordPress / WooCommerce.

2020, June

2020-06-30

• Import: Draft Orders – do not preload Draft Orders if there is no “Name” column – to make it faster. Use the “Number” column to mark which rows belong to the same Draft Order.
• Import: tell in Import Comment when existing Draft Order / Discount / Customer is found by Name / Code / Email (instead of telling that it is found by Handle).

2020-06-29

• Fix: Import: Magento – calculate the correct variant price if it was modified for specific options, as price correction.

2020-06-27

• Export: ITG Orders SAP CSV format – include Shipping Company in the AG column (33: Receiver name-2).
• E-mails:
  • Unsubscribe link in the e-mail footer.
  • Show Job ID in the e-mail body.
  • Changed default e-mail settings: sending e-mail only when the Manual job failed or finished; and only when Scheduled job canceled or failed. You can change when the e-mail is being sent in Matrixify Settings.

2020-06-23

• Import Collections – tell the exact error why the import of a collection failed instead of just saying that another such collection might exist.
• Export: Google Shopping – to set any field as blank, have the Metafield or Variant Metafield with value “<EMPTY>“.
• The incident with the Shopify API call limit is resolved. We continue to monitor the situation.

2020-06-17

• Fix: UI – Batch Job was showing filters of sub-jobs, and was not showing sub-job-state.
• Fix: Working with SFTP which has denied directory listing outside the home directory.

2020-06-15

• Fix: UI – could not open “All Jobs” page on a slower internet connection.

2020-06-12

• Fix: UI – show shorter FTP/SFTP links so that the error message fits in the message box.
• Fix: Import – Products: deleting over 100 images for a Product caused Shopify API to time out, so it was retrying 50 times before it gave up, making such import very slow.
• Fix: Import from FulfilmentCrowd FTP server.

2020-06-11

• UI: Job List – show in dropdown only relevant states and their counts when filtering jobs by State.

2020-06-09

• Import: Products – because you can import a Product into several Custom Collections by separating them with “,” – if you need to have a custom collection with a comma in the collection title, then escape it as “\,”.
• Fix: UI – recent job list to show max 5 jobs or all unfinished.

2020-06-06

• Fix: Import: get the real file name if uploading from web URL which redirects to another URL.

2020-06-05

• Export: If format is Excel and any of the sheets has more than 500,000 items, then automatically switch to zipped CSV format, because this will most likely exceed Excel limit of 1 million rows.
• Export: Google Shopping Data Feed – export shipping_label field. Also, any field names that had space, now have _ (underscore) as a word delimiter, which is a more precise Google Shopping format.
• UI: Filter [All Jobs] history by ID, File Name, State, Entity, Queue, Created At date.

2020, May

2020-05-30

• Import & Export: Products – allow to set Variant as “Stocked”, and export Stocked locations.

2020-05-29

• Import: Ignoring invalid characters in CSV files that cannot be converted to UTF-8 encoding.

2020-05-28

• Import: Customers from WordPress / WooCommerce using API.

2020-05-27

• Fix: Import from CSV – if CSV file had BOM, and it contained invalid UTF-8 characters, then the other encoding was assumed, which caused the first column name to be corrupted.

2020-05-26

• Import: Auto-detect CSV file encoding, like UTF-8, ISO-8859-1 (Latin 1), ISO-2022-JP, etc., and automatically convert to UTF-8 as needed for Shopify.

2020-05-25

• Import: Products from WordPress / WooCommerce using API. Put the link to API in Matrixify import URL: https://api_key:[email protected].

2020-05-22

• Fix: Import: getting around CSV file issue which gave an error – Unquoted fields do not allow new line <"\r"> in line 1234567.

2020-05-20

• UI: view All Jobs history with pagination.

2020-05-17

• Export: Specify custom file names also for all other export formats, not just for Matrixify.

2020-05-16

• Import: from Google Sheets as CSV file by specifying ?format=csv at the end of the Google Sheets URL.
• Import: specify the custom file name for Result file, and whether the Result file should be zipped.

2020-05-13

• Fixed: FTP – ability to work with DriveHQ FTP servers.

2020-05-12

• Fixed: Import: Orders – create Fulfillments where products and Gift Cards are in the same Fulfillment.
• Import: Tell if there are any errors with file columns as soon as possible, before scanning through data rows.

2020-05-11

• Import: WordPress Pages – generate Handle from slug if the page is a draft.

2020-05-10

• Export: Metafield columns selector (under Advanced tab) – to include only Metafield columns that match specific Namespaces, Keys, and Types.

2020-05-09

• Import: Orders from Magento – conversion from exported Magento DB CSV files with Dry Run to Matrixify template is now much faster. Even for migrations over 1 million Orders.

2020-05-06

• Fixed: Import – sometimes reading Excel cell value which looked like HTML code, was wrapped in <html> tags.

2020-05-04

• Import Orders – Dry Run quicker by not checking if Line Item SKUs exist in the store. That is also impacting the Dry Run file conversion from other formats like migrating Orders from Magento.

2020-05-03

• Import Orders – generate Fulfillments only for line items which are not Gift Cards, because Shopify generates Gift Card Fulfillments automatically.
• Export: Products – made it a bit faster when exporting with included Collections.
• Fixed: Export Products – when combining filters of Collections and Tags – was filtering only by Collections, but not by Tags.

2020-05-01

• Import: CSV – when there is an error parsing specific CSV file row, tell what was previously known correct row values, so that you can find the wrong row easier.

2020, April

2020-04-30

• Fixed: Uploading files larger than 200 MB got stuck. Remember that you can upload files up to 2 GB in size. Non-Excel files can be even zipped to make them smaller.

2020-04-29

• Import: Orders – group Transactions by kind, status, and gateway – to allow separate gateways appearing as separate transactions.

2020-04-28

• Fixed: UI – Export: when filter has very long text, cut it off so that you can remove the filter too.

2020-04-27

• Fixed: Import from FTP/SFTP when password contains #.
• Import: Products – assume Fulfillment Service as “manual” for new products which have inventory, but have not specified any Fulfillment Service.

2020-04-25

• Export: Google Shopping – include “adult” column, with value taken from Metafields, Options, or Tags.

2020-04-24

• Export: Google Shopping – cut description to 5000 characters even if forced Metafield value is longer than that.
• Import: Products from Magento: include the “type” and “tax_class_id” fields as Metafield and Variant Metafield.
• Import & Export: Products which are Gift Cards. New column “Gift Card” for Products sheet.

2020-04-23

• Import: Retry saving items in case of the “expected Array to be a Hash” error from Shopify API.
• Export: do not remember Options from the latest Export job.
• Fixed: Import Customers – delete addresses for customers which have more than 10 addresses.

2020-04-22

• UI: Show job ID in the job list.
• Fixed: Import Orders and Draft Orders – “Additional Details” ability to escape the name with \:.
• Fixed: Cannot export more than 10 customer addresses.
• Fixed: Updating only Draft Order Additional Details wipes out any customer details including address.

2020-04-21

• Fixed: Import: Product images from AWS S3 which have escaped space symbol %2B in the file name.
• Fixed: Updating only Draft Order Additional Details field wipes out any customer details including address.

2020-04-17

• Export: Select individual fields to export for all the data entities in the Advanced tab.

2020-04-15

• Fixed: Export Customers – ability to choose columns: Send Account Activation Email, Send Welcome Email, Password, Multipass Identifier.
• Import: Orders and Draft Orders – link line items to Product Variant by having only the “Line: SKU” value. This will also link migrated Magento Orders to the Products in Line Items.

2020-04-11

• UI: Double-confirm when exporting Customers with Activation URLs – to avoid accidental resetting of previously generated Activation URLs.
• Export: Fixed estimates when exporting filtered items.

2020-04-09

• Fixed: Export – filter by “Created At”.

2020-04-08

• Fixed: Export – Amazon, eBay, etc – get variants when filtering by collection.
• Fixed: Download exported files that are larger than 1 GB.

2020-04-05

• Import: Products form “Bespoke Factory” supplier format.

2020-04-03

• Fixed: Import Products – remove surrounding spaces from Template Suffix values.

2020-04-01

• Import: Orders from Magento v1.11 with older table structure.
• Import: Smart Collections – warn in Import Comments if sorting products in Smart Collections times out (Shopify might still be sorting products in the background).

2020, March

2020-03-31

• Newest Shopify API version 2020-01 (requires approving additional API permissions).
• Import: Collections – if the related “Product: Handle” will not exist in the store, then it will not fail, but will just give the warning in the Import Comment.

2020-03-23

• Fixed: Import – Products: properly delete and re-create variants when importing with “Variant Command” as “REPLACE”.
• UI: Show special window if opening tabs of several shops in the same browser, which mixes up Shopify Admin sessions.

2020-03-19

• UI: Made Matrixify work with some older versions of Edge, Opera and Firefox browsers (let us know if something doesn’t work).

2020-03-18

• Fixed: Export – if cannot determine the count of a specific entity from Shopify, then just tell that could not get the count, instead of retrying 50 times.
• Fixed: Export: Sometimes there were no columns selected when selecting column groups.

2020-03-17

• Import: Customers – when using Command “REPLACE”, sometimes existing customer was not found when it actually existed when it was recently created.
• Export: ITG format – do not assume filters, but allow customers to apply their own filters.

2020-03-16

• Fixed: Import – Products: Solved the error when updating inventory quantity which said “Write requests to inventory_quantity and inventory_quantity_adjustment are no longer supported. Please use the Inventory Levels API.”.
• Export: Added option [Export items sorted in the order as they come from Shopify] – by not generating export rows in parallel.

2020-03-12

• Fixed: Scheduled/repeated job scheduling across daylight savings.

2020-03-11

• Fixed: Import WordPress – set the Published At date if Post or Page has status which includes the word “publish”, as it varies by WordPress version.

2020-03-10

• Fixed: Export: Products – include the columns if only Variant Cost or Variant Customs columns selected with no other Variant columns.
• Import: Magento Products – extract the “short_description” field to “Metafield: magento.short_description” column.

2020-03-09

• Import: WordPress Posts and Pages: convert also links to images – to point to new Shopify uploaded image.
• Import: Magento – recognize the Magento Products exported file more precisely – don’t require the [msrp_display_actual_price_type] field because Magento versions don’t have it.

2020-03-06

• Fixed: Import Orders and Draft Orders – was failing that cannot find the Customer when importing with [Ignore ID] option, and it had [Customer: ID] provided.

2020-03-05

• Import: Products from Lightspeed POS platform.
• UI: Export – Products: columns for [Inventory Available: …] and [Inventory Available Adjust: …] – as a group of all locations, instead of each location column separately.
• Import: Products – skip the variant data if the first variant row is empty.
• Export: Products – Filter by SKU starts with.

2020-03-04

• Fixed: Import was failing if there were any empty sheets without data.
• Fixed: App UI – crash if uploading the file before the job list was loaded.
• Fixed: Export Products: “Variant Inventory Qty” was empty if choosing that field to be exported without “Variant Inventory Tracker” field.

2020-03-03

• Import: Products from Banggood – keep the images in Body HTML by default. If you need to remove images from Body HTML, set the Import Option: [Remove images from Body HTML].
• Fixed: Import: from URL with space in it – both escaped or non-escaped should work now.
• Export: Google Shopping – take the Metafield values also from Variant Metafields, if they exist.
• Import: Orders – fail if [Refund: ID] is not a number.

2020-03-02

• Import – ability to read from CSV files larger than 2 GB, zipped.
• Fixed: Export to Amazon, eBay and Google Shopping – include data from Metafields.

2020, February

2020-02-29

• Settings: Configure job notification e-mails more precisely – Started, Queued, Cancelled, Failed, Finished.

2020-02-28

• Fixed: Export: Don’t allow %D in the custom file name, because it generated date as d/m/y.
• Export: customize which columns to export, and change columns positions (in Advanced tab).

2020-02-27

• Fixed: Import from URL with date placeholders was saving the interpolated URL instead of dynamic.

2020-02-26

• Fixed: Import from Google Sheets wasn’t downloading.
• Fixed: Export to FTP/SFTP couldn’t be created if the password contained % symbol.
• Fixed: Import – Products: ignore inventory quantity for empty inventory location, got rid of “Location [Adjust] not found” error.
• Export: Activity – Path as a full URL to the item.

2020-02-25

• Export: Activity – Shopify events log.

2020-02-24

• Import: Products – when deleting all variants of a Product, assume the default variant with the data from the last variant and no options.
• Fixed: Don’t start another repeated job if the previous is not yet finished.

2020-02-21

• Scheduling: Daily, weekly, monthly, yearly jobs will start at the same local hour:minute regardless of daylight savings.
• Safari browser now should work as well. Please, contact Matrixify Support if you experience any issues with Safari or any other browser.
• FTP: Allow connecting to FTP servers using SSL/TLS encryption even if the server certificate is not configured correctly.

2020-02-20

• Fixed: Import – Products: [Failed. Inventory Policy: is not included in the list] if Variant Inventory Policy is empty.

2020-02-19

• Fixed: SFTP server “permission denied” and “bad message” errors fixed.

2020-02-17

• Import: continuously import all files from an FTP/SFTP directory as a Batch import job.
• Import: when importing from FTP/SFTP server – specify an option to either delete the file when it’s being imported; or move imported files to folders by job status: In Progress, Finished, Failed, Cancelled.
• Import: option to upload Import Results file to an FTP/SFTP server directory.
• Import & Export: Import Results file name and default export file name now has seconds to not overwrite files if two imports finish in the same minute.
• Import & Export: Validating FTP/SFTP URLs before creating the job.
• Import & Export: allow to set an option to repeat jobs every minute.
• UI: latest jobs sorting – don’t show on top the canceled scheduled jobs which are in the future, but put them in chronological order when they were created.

2020-02-15

• Fixed: Import Products – remove accidental spaces from Variant Inventory Tracker, Variant Inventory Policy, Variant Fulfillment Service – to avoid unexpected error message from Shopify because of that

2020-02-14

• Fixed: Import: Products – “Key: must be unique within this namespace on this resource” when adding Metafields and simultaneously changing Tags and Options.

2020-02-07

• Export: Orders using the Shopify API cursor to make them export safer and faster.
• Import: Magento Products – don’t allow to generate more than 1000 variants from option combinations, because Shopify anyway allows 100 variants.

2020, January

2020-01-30

• Export: Google Shopping Feed – added the ability to export feed file as a regular CSV file instead of tab-separated .txt – for certain shops. If you need it too, please, let us know via Matrixify Support.

2020-01-26

• Import: Banggood Products – convert Tag, Type and “Custom Collections” comma to ” &” to not confuse categories that have a comma in their name.

2020-01-25

• Import: read CSV files with unescaped ” – work around error: “Any value after quoted field isn’t allowed in line x”.
• Import: Banggood Products – trim ” from both ends for Title.

2020-01-24

• Import Product images – don’t re-encode the image URL if it has encoded comma %2C character – because some web servers need an encoded comma.

2020-01-22

• UI: removed HotJar Poll.

2020-01-21

• Export: Allow only legit characters for the custom filename.

2020-01-20

• Fixed: Import – Magento Products – take custom options only from an empty option store, to avoid combining options from all languages.
• UI: HotJar Poll about Matrixify.

2020-01-17

• Make the Matrixify App work on Chrome 80.
• Import: Order – “Line: Type” column validation, to allow only recognized values.
• Fixed: Export – Blog Posts: Do not create multiple rows per Blog Post with comments if comments are not exported.

2020-01-16

• Import: LightSpeed Orders – assume Tax Rate 0% if VAT is 0.

2020-01-15

• Import: Orders – if cannot find Line Items for Fulfillments by any of unique attribute values, then assume by Fulfillable Quantity.
• Import: Orders – show exactly which Line Item product has no price.
• Import: Orders – read Discount Line amount also from “Line: Discount” column, if “Line: Total” empty.
• Fixed: Export & Import – falling back to zipped CSV if cannot save the file to Excel.

2020-01-08

• Settings: show Approved Documents status with timestamp signature.
• Import: Body HTML – remove specific invalid UTF-8 characters when importing, like “”.
• Fixed: Orders Import – require the Line Item price only for new Orders and new Draft Orders.

2020-01-07

• Import: Draft Orders – allow to import percentage discount without specifying the discount price amount, but just percentage.
• Fixed: Import Products – error “Cannot find the variant by title […] to attach the image”.

2020-01-06

• Export: Orders – new column “Checkout ID”.
• Import: Magento: Generating variants from custom options with radio custom option type.

---

2019

2019, December

2019-12-28

• Fixed: Import – Discounts with multiple Codes – retry if failing to create a Discount Code.

2019-12-25

• Import: Product Images – when importing images split by ; without specified position – make sure the existing images stay where they are, but added images add added to the end. As a result – also improved overall matching of images by URL/file name, and attaching them to variants.

2019-12-23

• Import Products from Magento: take the variant price from _custom_option_row_price column if generating variants from options and price is 0.

2019-12-22

• Privacy: in the spirit of GDPR and CCPA – removed all the individual user tracking. Kept only aggregate tracking on Google Analytics and individual app actions log for security reasons.
• Fixed: Import Product Images – NoMethodError – undefined method key? for nil:NilClass.
• Export: always include SEO Metafields [Metafield: title_tag] and [Metafield: description_tag] when exporting Metafields for Products, Collections, Pages, Blog Posts.

2019-12-21

• Import Products: generate variants from Options separated by ; only when column “Variant Generate From Options” is set to TRUE.

2019-12-20

• Import Products: Optimized speed when importing images with Alt Text.
• Import: Allow special symbols like @®©℗™ªº in Handle, when not transliterating Handles.

2019-12-19

• Fixed: Import Customers – set new tags and other attributes when replacing addresses.
• Import: optimized speed when importing Custom Collections column from Products sheet – not trying to add when product is already in that collection.

2019-12-18

• Import: if there are any Failed items, show a summary of why they fail.
• Import: Products by SKU – smart preload to faster index products by SKU.
• Fixed: When saving Excel file which has more than 1 million rows – fallback to zipped CSV file with correct file extension.
• UI: Job view – show estimated finish date & time as hover for the estimate time while the job is running.
• Fixed: Import Product Images – set image Alt Text when importing existing image with Image Command REPLACE.

2019-12-17

• Import: Products – recognize options also from columns like “Option 1 Name” – with extra spaces in column name.
• Fixed: Import: WordPress Posts & Pages: when having empty Title or Handle – set them to ID value.
• Fixed: Import Metafields – delete or update Metafield even if namespace or key is surrounded by a space in Shopify database.

2019-12-16

• Import Orders from Magento: auto-detect CSV file delimiters for your exported file from database. Recognize: , ; | tab.

2019-12-13

• Import: removed “Preload existing items from Shopify” Option because people were accidentally messing their data by unchecking this box. And the speed gain is not so significant to risk it. Will monitor how many people really need it.
• Run your previous job again by pressing button “Export Again” or “Import Again”.
• Fixed: Import Products – if you change just Option2, then require to include also Option1.

2019-12-11

• Image import: Recognize and return an error when Image Alt Text is too long and rejected by Shopify.
• Fixed: Downloading 9GB Import Results file should no longer timeout in any case.

2019-12-10

• Import: Orders and Draft Orders – strip HTML from Line Item “Title”.
• Import: detect sheet if file name has several extensions, e.g. “Import.2019-discounts.csv.zip” will get assumed as “Discounts”.
• UI: For each job show its “API Call Limit”, “Threads” count, and whether the job was ran in “Private App” mode.

2019-12-06

• Import: not pre-loading whole store items before starting an import (except for Draft Orders) – so that store items don’t get overwritten by the app if changed from Admin while the import is running.

2019-12-05

Orders

• Import Orders: Allow fulfilling line items by filling “Fulfillment: …” columns in “Line Item” rows.
• Import Orders: Take “Fulfillment: Shipment Status” date from “Fulfillment: Processed At” – import only.
• Import and Export Orders: Split “Fulfillment: Tracking Number” and “Fulfillment: Tracking URL” semicolon-separated into several tracking numbers or URLs.

UI

• Settings: Allow setting up the private app in Settings -> Private App section.
• General: Display subscription expiry date and display warning if it’s less than 24 hours from now.
• Import Options: change “Check if items already exist” to more dramatic checkbox “Preload …”.

2019-12-03

• Export and Import: show correct column colors for Excel file even when column names are in lowercase.

2019-12-02

• E-mail: Subject for queued jobs changed from “Export Postponed on …” to “Export Queued on …”.

2019-12-01

• Import: Orders allow up to 100 different Taxes with columns: “Line: Tax X Title”, “Line: Tax X Rate”, “Line: Tax X Price”.
• Import: Improved error message if importing an unknown file format.

2019, November

2019-11-29

• UI Fixed: show months for the export filter date picker.

2019-11-28

• Import: Magento: collecting variant images also from media_image column.
• Retry the GraphQL request if Shopify API has SSL errors.
• Import: Discounts – show a full error from Shopify if discount code already exists.

2019-11-27

• UI: Show long filenames so that they fit on the screen.
• Export: added filters for Discounts Title: “contains none of”, “matches pattern”.

2019-11-26

• Save the file to CSV format if failed saving to Excel file.
• Import: Banggood – recognize more options.
• Fixed: Import – detect delimiters in CSV files that have \r line endings.
• Fixed: Export – “Processed At” filter for Orders to filter also by the time when using Relative Date filter.

2019-11-25

• Export “Tags Command” for Blog Posts. Unify colors for all “Tags Command” columns for exports in all sheets.
• FTP: Retry uploading files to FTP if failed.
• Import: Banggood: Improved option parsing and price correction calculations.
• UI: Mobile improvements for Counts and Totals

2019-11-22

• Import: execute different Tags Command by rows for Products, Customers, Draft Orders, Orders, Blog Posts.
• Import Products: faster updating of Products.

2019-11-21

• Fixed: Import Products: allow combining DELETE and REPLACE in Image Command.

2019-11-19

• When importing from external formats like WordPress, Magento, Banggood – recognize also file names in a singular form.

2019-11-18

• Magento: taking images from “gallery” and “media_gallery” columns to Product images and variant images.

2019-11-15

• Import Products from Banggood: allow to set in import Options – to remove images from Body HTML, or to keep images in Body HTML.
• Improved export estimates.

2019-11-11

• Added Security Settings: to allow or deny to download Matrixify files by external services.
• Fixed: UI – should be able to accept GDPR popup when viewing from small screens or mobile.

2019-11-06

• Retry connecting to the FTP server 10 times, before giving up. Show error message which comes from the FTP server.

2019-11-05

• Fixed: Import from WordPress: don’t fail the whole job if cannot download one image with an unhandled error. Show that error in Import Comments.
• Fixed: Make importing Products with Tags and Options simultaneous changes fast again.
• Import: Magento Products – include “material” column as a Metafield.

2019-11-04

• Fixed: Export Filters – reset filter value when switching between filter fields.
• Fixed: Export Filters – status filter crashed UI.
• Fixed: Export Filters – properly specifying max dates for daylight savings winter time.
• UI: Polaris version upgrade to 4.7.2.
• Fixed: Don’t send an email twice when a job can’t connect to the Shopify.
• FTP – try connecting to FTP using SSL/TLS.
• Fixed: FTP – catch all connection issues, and retry without SSL if SSL is broken.

2019-11-01

• Import: Banggood – improved options conversion to variants.

2019, October

2019-10-31

• Import: LightSpeed Products – decompose options with quotes in it.
• Fixed: Import from Products with Google Shopping fields and “Metafield: description_tag” – was a duplicate key error.

2019-10-30

• Import: LightSpeed – detect CSV delimiter, sort the whole file before converting, remove the country prefix from column names.
• Import: Tell that “Title cannot be blank for Products import” – to hint that this is Products sheet, in case you didn’t specify the correct sheet name.
• Fixed: Import – Orders with Refunds with processed_at date that have no transactions.
• Export: Google Shopping – use SKU value for ID only if SKU has any value. If SKU is empty – generate the full Google Shopping ID from Product ID and Variant ID.

2019-10-28

• Import: Magento Orders – if “Customer: Last Name” is empty, then put the First Name in the Last Name field, because the Last Name is a required field in Shopify.

2019-10-25

• Mobile: make the job list look better when using Matrixify from the mobile phone.

2019-10-24

• Import: allow updating Discounts by ID, without specifying the Discount Title.
• Import – rescue from job crashes if filename is not encoded as valid UTF-8 characters.
• Fixed: Export to UPS WorldShip – AccessPointID to the correct element.

2019-10-23

• UI: Long item counts for export or import – not to overlap; better visibility on mobile.
• Import: “Tag” and “Tag Command” column aliases for “Tags” and “Tags Command” columns.
• Fixed: Import Blog Posts – convert Blog Handles to Handles before creating them, to avoid blog duplicates.

2019-10-22

• Settings: Improve linked shop message for changing once per month.
• UI: Stop reloading jobs list when the shop is uninstalled, but the app stayed open in another browser.
• Fixed: Import Smart Collections with product positions, make sure to always wait until those positions are updated in Shopify.
• Send e-mail even when job failed with an unexpected error.
• Fixed: Import from WordPress: make it more stable on images that cannot be downloaded.

2019-10-21

• Schedule the next job even if unable to connect to Shopify, as this might be a temporary issue.
• Import from Magento: if Variant has 0 Price – take it from Parent product.
• Shopify reconnection improvements, so that the job doesn’t get stuck.

2019-10-17

• Import: Validating image and variant position.

2019-10-15

• Export: Auto-select “Order Line Items” checkbox if “Line Item Data” checkbox selected – so that there are Line Items in the exported Orders.
• Import: Orders – Transaction as gift_card gateway changed to manual.
• Export: Filters sorting improved.
• Fixed: Import – Discounts: “Applies To” with duplicate values failed.
• Export: Date filters – add some, and remove some which don’t exist actually.
• Import: Magento – put the quantity in Variant Metafield.

2019-10-14

• Import: Magento: Adding “Magento” prefix to the generated Metafields.
• Export: Filters for dates – Created At, Updated At, Published At, Relative.

2019-10-10

• Shopify API: upgrade to version 2019-10.
• Import: Magento – MSRP and other fields as Metafields.

2019-10-08

• Fixed: Import Orders/Draft Orders – allow escaped \: in “Additional Details” and “Line: Properties” columns.
• Fixed: Export count when filtering by IDs.
• Fixed: Import from WordPress – catch SSL error when downloading images.
• Export: Show count of exported items.

2019-10-04

• Fixed: Export – Order Filters with default statuses.
• Import: Recognize sheets like “blog-posts”.

2019-10-03

• Fixed: Import Blog Posts with Big or Enterprise Plan created duplicate Blogs.
• Export: Filters – combine different filters in the same export.
• Fixed: Import – truncate generated Handle to 255 symbols because it is maxed in Shopify.
• Import: Failing job on variant loading error with a proper message.

2019-10-02

• Fixed: Import from WordPress: conversion comments were empty for failed images.
• Fixed: Import from WordPress: invalid URI, validate old server URL, don’t download HTML as an image.

2019-10-01

• Fixed crash during job canceling.
• Import: Improved performance of the multithreaded discount code import.
• Fixed: Import from WordPress: don’t crash if redirection is not allowed.

2019, August

2019-08-31

• Import Magento Products custom columns as Metafields to Shopify.

2019-08-27

• More filters for Shopify Orders export.

2019-08-21

• More filters for Shopify Blog Posts, Pages and Collections export.

2019-08-15

• Added safety checks for Shopify data Import.

2019, July

2019-07-22

• More filters for Shopify Products export.

2019-07-16

• New Matrixify App User Interface.
• Queue your Shopify imports and exports.

2019-07-08

• Import Option: Import items in the same order as they appear in the file.

2019-07-04

• When you select to export Orders with “Line Items Product Data” – you will see the additional column “Line: Variant Cost” among other product data columns.

2019, June

2019-06-18

• Do not update Metafields that are cut off at 32767 characters when edited in Excel.

2019, May

2019-05-24

• Change which allows you to import all 250 images for each product, which is the Shopify maximum.

2019, April

2019-04-10

• Added ability to combine multiple export filters.

2019, March

2019-03-25

• Added “Address Command” for Customers import and export.

2019, February

2019-02-22

• Added new filters for Export, allow combining some filters.

2019-02-17

• In History, you can see for each job – how much time did it take to run it.
  For the jobs which are still running, the time shows how long it was running so far.

2019-02-06

• Made Shopify Export Faster.

2019, January

2019-01-29

• Now, when you run the “Dry Run” it will check more things about the file you import.
  It will go with importing as far as possible, but not send any data to Shopify.

2019-01-25

• When you export to eBay format, all the product variants will get included as “Variations” in the eBay template.
  Read the full eBay export template specification to see all the exported fields.

2019-01-10

• You can now filter Orders by Name fragment.

2019-01-03

• The following changes are made to Shopify Discounts:
  • Import and Export the “Minimum Number Of Items” – to apply the discount code for certain minimum quantity of ordered items.
  • Fixed the “Code: must be unique” issue when importing Discounts.
  • When importing Discounts – it will not pre-load existing Discounts anymore, so the import of Discounts will be faster in most cases because you will not have to wait for it to pre-load existing ones.

---

2018

2018, December

2018-12-18

• Ensure that only one Scheduled/Repeated job is running in parallel by postponing others.

2018-12-08

• Now Matrixify can understand better what you are importing from each sheet. Your sheet names can be lowercase.

2018-12-07

• You can export your Metafields now also to the “Matrixify: CSV” format as well.

2018, November

2018-11-20

• Whatever time you put in the date/time columns – the Matrixify app should now recognize the correct time format.
• Export and import Shopify Draft Orders.

2018-11-15

• New Export filters by Tags and by IDs.

2018-11-12

• Changes to Discounts – allowing Discounts between Shopify stores with linked Products.

2018, September

2018-09-18

• You can now export and import the “Buy X Get Y” type discount code using the Matrixify app.

2018-09-17

• Now the Amazon Inventory Flat File export contains the column “department_name” where the Department is exported – so that you can prepare it in Shopify and import it to Amazon.

2018-09-07

• Now you have an option to NOT compress those CSV files into Zip file but export them as plan CSV/TXT files.

2018-09-01

• When you request from Shopify Admin to remove the Customer data, then the app will receive this request from Shopify and will remove all the exported, uploaded and imported files which were related to Customers or Orders. When you delete the app, then all your files are deleted from the app history.

2018, August

2018-08-31

• Now you can filter the export of Shopify Customers by the Tags and by Date Updated (in addition to the previously existing filter by Date Created).

2018-08-29

• When exporting Shopify Orders, now you can use additional filters to filter by the order “Status”, “Payment Status” or “Fulfillment Status”.

2018-08-22

• You can now export data from Shopify to SFTP file server, and import from SFTP to Shopify.

2018-08-02

• When you export the Custom Collections with Linked Products – now you will always have also the “Product: Handle” column filled in with the Handle of the Product.
  When importing, the app will try to attach products by both columns – “Product: ID” and “Product: Handle”.

2018, July

2018-07-31

• Now you can create and update Order Fulfillments so that you can set a specific shipment status for your Orders in the import table, too.

2018-07-19

• Now you can set the relative time filter as “Last x minutes / hours / days / months” for the time when the Order was created.

2018-07-13

• There are the following new columns that you can import for Orders:
  • Send Receipt
  • Fulfillment: Send Receipt
  • Inventory Behaviour
• You can have one line of “Line: Type” with value “Fulfillment Line” for the whole Order to be fulfilled.

2018-07-10

• You can now apply the filter of the Published Status – as published or unpublished.

2018, June

2018-06-26

• Now the app will import all the tags that are in all the product rows.

2018-06-20

• Now you can also make imports and export repeat by minutes (with minimum 5-minute steps).

2018-06-18

• You can now update some of the fields for your existing Shopify Orders without having to re-create (replace) them using “UPDATE” in the “Command” column.

2018-06-06

• You can bulk import and export the Shopify Redirects (also known as 301 URL Redirects).

2018, May

2018-05-24

• You can filter Collections by IDs, Handles or Titles. To filter by several Collections, split them with a comma.

2018-05-23

• The filters will reset after each export, so that you don’t have to clear them out each time.
• When running the export, the exported file will contain the “Export Summary” sheet with the summary data about the export – what was exported, and what filters were used
• We have implemented the GDPR regulation requirements.

2018-05-13

• You can now Export, Import and Update Shopify Blogs the same way as you do with any other items.

2018-05-03

• Now there is a column “Variant Weight” where you can set any value in the units as you specify in the “Variant Weight Unit“.

2018, April

2018-04-25

• Now there is a “Variant Tax Code” column for Shopify Products export and import.
  Specifies the Avalara tax code for the product variant. Will export and import only for stores that have the Avalara AvaTax app installed on your Shopify Plus.

2018-04-09

• When exporting Product Images or Collections, you will see new columns “Image Width” and “Image Height” in pixels for each of the images. Those columns are only exported.

2018-04-08

• When you import the data, you can specify the “Tags Command” column for Products and for Customers.

2018-04-05

• If you want to export only products that don’t match any of the listed SKUs, by using SKU filter condition “not equal to any of”.

2018, March

2018-03-24

• You can filter products export by Collection.

2018-03-23

• You can improve the speed by checking the “Ignore ID” box and that will tell the app not to try to use those IDs if migrating from another store.

2018-03-22

• You can now schedule exports to a certain date and time, and set to auto-repeat them.

2018-03-20

• If you have a store that is so large that the data don’t fit into an Excel file, now you can choose to Export into the “Matrixify: CSV” format.

2018-03-17

• You can schedule and repeat imports to your Shopify store.

2018-03-13

• Now when you export Product Images from Shopify, the Image Alt Text column will be there always and the export and import of product image alt texts works super fast now.

2018-03-12

• You can filter Products by Vendor in finer detail:
  • Vendor equals any of several vendors, split by comma
  • Vendor not equal to any of several vendors, split by comma

2018-03-08

• When clicking the “History & Schedule” button, you can see the whole history of your imports and exports, their statuses.
  You can also download all your historically imported and exported files and you can cancel the scheduled jobs from there, too.

2018-03-07

• There is a new column “Image Alt Text” in Smart Collections and Custom Collections sheets now to export Image Alt Text for your Collections.

2018-03-05

• Now you can update by SKU number all your products, even if they are not unique across your store.

2018-03-03

• You can now export and import Line Item properties for Shopify Orders.

2018, February

2018-02-12

• When exporting Products, the export contains the URL column, which takes to the Product page.
• Now you can bulk update, delete, and do all the other things to Products by just knowing its SKU number. No need for ID or Handle by using the column “Variant SKU”.

2018-02-02

• You can import Orders to Shopify in bulk now with all the details.
• When exporting from Shopify, you can filter Products by Price

2018, January

2018-01-14

• You can filter Products – to export only those, which contain fragments of SKU.

2018-01-16

• You can remove images (<img> tags) from your Body HTML description by selecting a checkbox option “Remove images from Body HTML” when importing.
  Here is the tutorial: How to remove images from Shopify Body HTML descriptions?

2018-01-13

• Fixed import errors like:
  • Field [metafields.key]: must be unique within this namespace on this resource – was happening because importing Metafield update, giving Metafield name in different small-BIG letters than already exists.
  • product_id prefix_option is missing – was happening when retrying to import product because Shopify didn’t download some images

2018-01-07

• When exporting Customers, you can filter by Customer registration date interval.

2018-01-03

• You can filter Shopify Products by many titles – put them in filter split by , (comma), and it will export only products that contain any of those titles.

---

2017

2017, December

2017-12-19

• Added Shopify Pages export and import with Excel.

2017-12-11

• In order to prevent further damage of Product images, when importing non-existing images, app will stop as soon as at least one product image will not be possible to download.

2017-12-05

• You can force the import to not check if such items already exist – this will speed up the import even more.
• You can export your Shopify Products to Google Shopping Data Feed file.

2017, November

2017-11-27

• You can filter export of Products by Handle, Title, Vendor, Type, and Tags, and you can filter Orders export by date.

2017-11-23

• Now you can choose more finer details what data to export for each item, so that you don’t have to delete unneeded columns and rows when updating data.

2017-11-15

• If Shopify will not be able to import all Product images, app will issue warning about that in Import Results file “Import Comment” column.

2017-11-14

• Product variant reordering can now be done by changing the “Variant Position” number and importing that column in as update.

2017-11-11

• When exporting, all the base rows like Title, Vendor, Tags, etc. are filled also for duplicated rows, so that you can filter and group them easier in Excel.

2017-11-10

• Metafields Import
  • Speed: Metafields import speed doesn’t depend on Metafield count anymore. Even for 100 Metafields per item, it will import as quickly as with no Metafields.
  • Delete: You can delete Metafields for items just by clearing values in that Metafield column, and importing.
  • Set type: Metafield can have “string” or “integer” type, which is now auto-detected from Excel cell type, and set correctly when you do the import.

2017-11-05

• Import speed dramatically improved

2017, October

2017-10-30

• To import or update several images for a product, put them all in the same row of “Image Src” column, separated by ; (semicolon). Read tutorial: How to import several product images from one row?

2017-10-26

• Order Export is now in Beta testing – export unlimited Order data to create custom sales reports, check fulfillment, and generate additional business intelligence data for your store.Read more in: Shopify Orders Export

2017, July

2017-07-07

• Matrixify Launched

---

Year -13,800,000,000

• The Big Bang