Get Excelify now
Get Excelify now

Import Gift Card Products to Shopify

9 - import gift card products shopify bulk excelify csv excel xlsx

Shopify Gift Card Products are basically the Shopify Products, so they also consume a lot of time to create manually.
That is why with Excelify you can import Gift Card Products in your Shopify store – in bulk!

Let’s look into how to do that!

1. Activate Gift Cards feature in your store

Before you can import Gift Card Products you will need to make sure that this feature is activated in your store.

Go to Shopify Admin -> Products -> Gift Cards in your Shopify Admin.

If Gift Cards feature is not yet activated then the following page will open:

1 - activate Gift Cards in Shopify

Here you need to press the button “Sell gift cards” and the feature will get activated.

If you do not see the page as above then you already should have the feature activated in Shopify.

2. Construct a Products file to import Gift Card Products

This section will be split into two parts – one to create the file manually from scratch; and the other on how to change your existing Products to Gift Card Products.

2.1 Construct the file manually

Now we can get to our spreadsheet!

Let’s create two different Gift Card Products from scratch.

Create a blank spreadsheet, name sheet/tab in the file to “Products” as we will be importing Products.

To create Gift Card Products from scratch we will only need 5 columns:

  • Title
  • Gift Card
  • Option1 Name
  • Option2 Value
  • Variant Price

Gift Card Products without variants

First, we will create a Gift Card Product that does not have variants with different selectable values.

  • Title – column set name of your Gift Card Product, for example, “My Single Gift Card”.
  • Gift Card – set the value “TRUE” in this column as we wish for the app to know to create this Product as a Gift Card Product.
  • Option1 Name and Option1 Value – for a product without variants, these columns can stay empty. If all your gift card products will be without variants then you do not need to have these two columns at all.
  • Variant Price – the price of your Gift Card.

2 - import gift card products shopify bulk excelify csv excel xlsx

Gift Card Products with variants

Now let’s create a Gift Card Product with multiple variants that are handled as denominations for Gift Card Products.

  • Title – In this example, we will have 4 denominations so we will need to fill the same Title in 4 rows. The app will use Title, in this case, to know which rows are from the same Product.
  • Gift Card – Fill with value “TRUE” for all rows.
  • Option1 Name – This would be the name of the option that your customers will see in the store. Usually its “Denominations”.
  • Option1 Value – Here you can write out denominations so that your customers can understand which option is how much value. But this is still a free text field, so any words or numbers can be written here. It’s important that each row here has its own unique option value.
  • Variant Price – fill with the actual price of each Gift Card product denomination.

3 - import gift card products shopify bulk excelify csv excel xlsx

You can also add other details to the product, such as images, description, etc. Check Excelify Products documentation to see all listed fields.

2.2 Changing existing Products to Gift Card Products

The process itself to change an existing Product to a Gift Card Product is quite simple.
But since Shopify does not allow updating that for existing Products then we will need to replace the product (meaning – delete and re-create it).

First, in the Excelify app, create a new export – select Products and all their sub-checkboxes.
Make sure that all columns show as selected to be sure that no information is lost when the product is being replaced.

You can also click on the “Filter” button to apply filters and export only specific Products that you wish to change to Gift Card Products in Shopify.

Press the “Export” button to start your export.

4 - import gift card products shopify bulk excelify csv excel xlsx

Once the file is exported we can start editing it.

In the file we only need to change the following columns:

  • Command – set to the value “REPLACE” in all rows for the product

5 - import gift card products shopify bulk excelify csv excel xlsx

  • Gift Card – set to the value “TRUE” in all rows for the product

6 - import gift card products shopify bulk excelify csv excel xlsx

3. Import your file to create Gift Card Products

Now we can again go into the Excelify app, in the Home page Import section you can upload your file.

Inspect all details about your import, to read what each detail means when importing, look into Excelify “How it works” page.

Press the “Import” button to start your import.

When importing new Gift Cards you will see Products being created as “New” when importing:

7 - import gift card products shopify bulk excelify csv excel xlsx

If changing existing products to Gift Cards – you will see the Products being “Replaced“:

8 - import gift card products shopify bulk excelify csv excel xlsx

4. Now you can sell Gift Cards!

To check your Gift Cards go to your Shopify Admin -> Products -> Gift cards -> Manage gift card products.

9 - import gift card products shopify bulk excelify csv excel xlsx

Good to know!