Get Excelify now
Get Excelify now

Release Notes

Christmas Latvia 2019

2019

2019, December

2019-12-11

  • Image import: Recognize and return an error when Image Alt Text is too long and rejected by Shopify.
  • Fix: 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
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 Fix: 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.
  • Fix: Import – detect delimiters in CSV files that have \r line endings.
  • Fix: 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

2019-11-21

  • Fix: 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

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

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

2019-11-04

  • Fix: Export Filters – reset filter value when switching between filter fields.
  • Fix: Export Filters – status filter crashed UI.
  • Fix: Export Filters – properly specifying max dates for daylight savings winter time.
  • UI: Polaris version upgrade to 4.7.2.
  • Fix: Don’t send an email twice when a job can’t connect to the Shopify.
  • FTP – try connecting to FTP using SSL/TLS.
  • Fix: 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.
  • Fix: 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.
  • Fix: 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 Excelify 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.
  • Fix: 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.
  • Fix: 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.
  • Fix: 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.
  • Fix: 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.
  • Fix: 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

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

2019-10-04

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

2019-10-03

  • Fix: Import Blog Posts with Big or Enterprise Plan created duplicate Blogs.
  • Export: Filters – combine different filters in the same export.
  • Fix: 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

  • Fix: Import from WordPress: conversion comments were empty for failed images.
  • Fix: 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.
  • Fix: Import from WordPress: don’t crash if redirection is not allowed.

2019, August

2019-08-31

2019-08-27

2019-08-21

2019-08-15

2019, July

2019-07-22

2019-07-16

2019-07-08

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

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

2019, March

2019-03-25

2019, February

2019-02-22

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

2019-01-10

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

2018-12-08

2018-12-07

2018, November

2018-11-20

2018-11-15

2018-11-12

2018, September

2018-09-18

2018-09-17

2018-09-07

2018-09-01

2018, August

2018-08-31

2018-08-29

2018-08-22

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

2018-07-19

2018-07-13

2018-07-10

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

2018, June

2018-06-26

2018-06-20

2018-06-18

2018-06-06

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

2018-05-03

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

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

2018-03-23

2018-03-22

2018-03-20

2018-03-17

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

2018-03-03

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

2018, January

2018-01-14

2018-01-16

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

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