Start Free Trial
Start Free Trial

Specify return type for Shopify Order Refund restocks

Refund Restock Shopify Orders in bulk|1 - Shopify partially fulfilled order bulk export Excelify|1.1 - Export filter Shopify order in bulk Excel CSV Edit|2 - Shopify Excel filter export order bulk edit||2.2 - Specify update columns Shopify Order export bulk edit excel csv update command|2.3 - Specify update columns Shopify Order export bulk edit excel csv Refund import|2.4 - Specify update columns Shopify Order export bulk edit excel csv Refund quantity b4|2.5 - Specify update columns Shopify Order export bulk edit excel csv Refund quantity aftr|2.6 - Specify update columns Shopify Order export bulk edit excel csv Refund in bulk Restock|3 - Import Shopify Order bulk update excel csv xlsx Refund restock|3.1 - Import Shopify Order bulk update excel csv xlsx Refund restock

The Matrixify app streamlines the management of your Shopify Orders, providing an efficient way to handle refunds in bulk. When you process a refund with restocking, the app grants you the flexibility to choose whether to restock and refund the portion of the line item that has already been fulfilled or the part that is yet to be fulfilled.

You can do so by using the column Refund: Restock Type.

Only used if:

  • Refund: Restock is set to TRUE
  • Restocking Line Item that is partially fulfilled
  • Restocking only part of the line item, not the whole quantity.

Allowed values:

  • If restocking fulfilled part of the Line Item set value return.
  • If restocking unfulfilled part of the Line Item set value cancel.

If you are Refunding with a restock all quantity that is still refundable for this line item then you do not need to fill this cell even if the line item is partially fulfilled. To create a Refund in this case, please follow the tutorial on  how to Refund existing Shopify Orders in bulk.
If the all quantity of the line item is fulfilled or unfulfilled then you also do not need to use this cell as the app will assign the correct value automatically for you. To create a Refund in this case, please follow the tutorial on how to Refund existing Shopify Orders in bulk.

The only case when you need to fill the “Refund: Restock Type” cell, is when you are refunding and restocking part of the refundable quantity of the partially fulfilled line item.

Let’s take a look at an example of how this is done.

Steps in short to Specify return type for Order Refund restocks

  1. Export the order you wish to refund with restock.
  2. Edit Exported file.
  3. Save, Import and enjoy!

1. Export the order you wish to refund with restock

First let’s Export an Order that you wish to refund with a restock.
As stated above, you do not need to use this column when Refunding whole line item quantity so for an example we will export Order that has a line item partially fulfilled.

Partially Fulfilled and Paid Order in Shopify Admin

First we must Export the Order with the Matrixify app. To do so, head to the Matrixify app and select “New Export”.

Select the export format “Matrixify: Excel” or “Matrixify: CSV”. We strongly suggest using the “Matrixify: Excel” file format if exported data is not over 100 000 items or will not exceed any of the known Excel limits.

In the Matrixify app Export section select “Orders” from the “Select Sheets” drop-down. For Orders, the only column groups you need to select are:

  • Basic Columns
  • Line Type
  • Line Items 
  • Refunds

If needed you can click on the “Filter” button and apply filters to only export Orders that you wish to work on. In this case, to only Export one Order, the “Name” and “Fulfillment Status” Filters have been added.

You’re Export set up should look something like this:

Export set up to Export Order for Restocking

Once the export is finished click on the “Download Exported File” button to download the file.

2.Edit Exported file

In the exported file we will need to make a few edits to create a refund.

Exported Order Excel

Remove columns that are not needed

By default, there are a lot of columns exported, so we will delete the ones that we do not require here. We will need the following columns:

  • ID
  • Name
  • Command
  • Line: .. (all columns that start with Line: )
  • Refund: .. (all columns that start with Refund: )

Only required columns for Import

Update column values

By default, the Orders are exported with the NEW value in the Command column. Since we wish to add Refund to existing Orders we would need to use the UPDATE command.

Changed Command to UPDATE for Import

The simplest way to show the app what item/s we wish to refund is to find the Line: Type column and update all Line Item values to Refund Line.
This will ensure that the app reads these rows as refunds and also creates them.

Changed Line Type to Refund Line

Now for each row that we updated to the Refund Line, we can set how many of this item we wish to refund. This is done in the Line: Quantity column.

Here we enter a negative amount, so if your Line Item quantity was 10 and you wish to refund 5 then you enter value -5.

Before:

Before Order quantity change

After:

After quantity change for Order

Fill Refund: … columns

  • Refund: ID set any kind of number there, for example, 1 for all the rows – just so that you identify that this is one and the same refund. You can create several refunds by changing the Refund: ID number, and group several line items into several refunds if you like.
  • Refund: Created At – Date when the Refund was created in Shopify. Export only – leave empty when creating a refund.
  • Refund: Note write any notes you want to add about this refund.
  • Refund: Restock put the TRUE value there if you want to restock the refunded products, or FALSE if you don’t want to restock.
  • Refund: Restock Type Only used when Refund: Restock is TRUE, and you are restocking only a part of a line item and it is partially fulfilled. To restock the unfulfilled part of the line item put the value cancel, to restock fulfilled part of the line item put return.
  • Refund: Restock Location – If you have the Refund: Restock set as TRUE, then you can set here the name of the location to which the restocked items should be sent. If you leave this empty then the items will be sent back to the default location.
  • Refund: Send Receipt put the TRUE value if you want the customer to receive an e-mail notification about that refund. FALSE – if you don’t. By default, it is FALSE.

In our example, we have Line Item with ordered quantity 10.
5 items are fulfilled and 5 are unfulfilled.

As we wish to Refund with Restock 5 items then, the same way as refunding in the Shopify Admin manually, we need to tell that those 5 are from the fulfilled or unfulfilled part of the line item.

We will Restock and Refund the unfulfilled part of the Line Item so we will set value cancel in the Refund: Restock Type column.

Filled in Refund columns for import

3. Save, import and enjoy!

Once you have finished editing the file, double check it, save and import it back into the app.

Go back to the Matrixify app and upload the file in the Import section. The app will analyze the file and count how many Orders you are importing.

Press the Import button to start the import.

If you see any Failed items, then after the import has finished, you can download the Import Results file and look into the “Import Comment” column. It will tell why particular Orders have failed. Then you can fix that issue and re-import just those failed and fixed rows again.

Completed Orders Import to Restock

Partially Refunded and Restocked Order

Warning!

Always test with just one Order to make sure you have it all set up correctly. It is important to test so that you can be sure of the Import process and make sure everything works as you expect it to!

And only when you have tested, import all the bulk changes.

Good to know!