Magento 2 cart price rules are an invaluable tool for running promotions. They work perfectly along with catalog price rules. And while Magento 2 lets you easily configure both, it is impossible to import cart price rules unless you use a third-party instrument. Thus, having migrated from Magento 1 or other ecommerce platform to Magento 2, you can find yourself in need of the solution to import cart price rules and coupon codes.
In this post, we will show you how to import coupon codes and cart price rules to Magento 2 with the help of the Improved Import & Export extension. You will discover how a sample cart price rule import table looks, what cart price rule attributes are used, and how to import Magento 2 cart price rules.
Table of contents
How to Add and Import Magento 2 Cart Price Rules post continues the line of guides for Magento 2 import/export guide list. The other articles in the line are:
As you probably know native Magento 2 import procedure doesn’t let you import or export cart price rules. So, there should be another solution which is Improved Import and Export Magento 2 extension.
Latest 2.1.2 release brings in basic Cart Price Rules import. At the moment the extension offers to import your coupon codes, all its basic settings with customer group and website conditions. Complex product conditions will be added soon.
In addition to the cart price rule import the extension has another great deal to offer:
- Import and export process automation with the help of cron scheduler;
- Support of both CSV and XML file types;
- Support of direct URL, Dropbox and Google Sheet import sources;
- Import and export of categories, orders, CMS pages, and all native Magento 2 entities.
And many more. For the full list of features – visit the extension’s product page.
Buy Improved Import Magento 2 Extension
Sample cart price rule import table
To start the import process you will need a sample import table or a properly formatted CSV or XML draft which you will fill with the proper data. The best way to get the sample file is to visit Google Sheet Master Table FireBear team has composed for you.
In the Master Table you can find sheets with sample data covering all possible import entities, such as customers, categories, products, etс. Every attribute columns comes with the short description and value samples. Take full advantage.
Read more about Google Sheet Master Table
If, for some reason, you want to create an import table from a scratch – keep in mind the following requirements:
|Character set||Unicode (UTF-8)|
|Field separator||Comma, Tab|
Cart Price Rule attributes
As with every Magento 2 import entity the cart price rules have a special attribute reference that you put into the table. Here is the full list of cart price rule attributes currently supported by Improved Import and Export extension.
|Attribute name||Reference||Values||Value example|
|name||Rule Name. The name of the Cart Price Rule||Can be any value||10% off|
|code||Coupon Code. The coupon customers will need to enter at the cart page to apply the discount||Can be any value. Leave empty if you use Auto Generation||test10%off|
|uses_per_coupon||Uses per coupon. The number of times the coupon can be applied to the cart||Can be any numeral value||10|
|description||Description of the cart price rule||Can be any value||A test 10% discount coupon imported with Improved Import and Export extension|
|from_date||The date from which the cart price rule is active||The date should be in the following format:
If you want custom design applied from 10th of July 2019, the value should look like:
|to_date||The date to which the cart price rule is active||The date should be in the following format:
If you want custom design applied from 10th of July 2019, the value should look like:
|uses_per_customer||Uses per Customer. How many times a single customer can apply this very coupon code||Can be any numeral value||20|
|customer_group_ids||Customer Groups. The IDs of the customer groups that are eligible to apply this coupon code||You can find IDs of the customer groups at Customers > Custom Groups > ID column of the group grid.
Use comma to separate multiple values
|is_active||Active. Defines if the cart price rule is enabled or disabled||0 – Cart Price Rule is disabled
1 – Cart Price Rule is enabled
|stop_rules_processing||Discard subsequent rules. Defines if only this very coupon can be applied. If enabled other coupon codes cannot be applied to the cart||0 – Discard subsequent rules disabled
1 – Discard subsequent rules enabled
|sort_order||Priority. Defines the order in which Cart Price Rules are applied to the cart. May be important if you offer several discounts at once.||Can be any numeral value. The lower the value – the higher the priority.||10|
|simple_action||Actions > Apply. Defines the type of the discount the coupon offers. Either a percent or fixed discount||Allowed values:
to_fixed – fixed amount discount
cart_fixed – fixed amount discount for whole cart
by_percent – percent of product price discount
|discount_amount||Discount Amount. The amount of the discount customer gets by applying Cart Price Rule||Can be any numeral value||15|
|discount_qty||Maximum Qty Discount is Applied To. Maximum quantity if the product the discount can be applied to. Quantity exceeding the set value will not be discounted||Can be any numeral value.||20|
|simple_free_shipping||Free Shipping. Defines if the items that are a subject to the discount should be shipped for free||Allowed values:
0 – No
1 – For matching items only
2 – For shipment with matching items
|apply_to_shipping||Apply to Shipping Amount. Defines if the discount should also be applied to the shipping price.||0 – no, the discount shouldn’t be applied to shipping
1– yes, the discount is applied to shipping
|times_used||Defines how many times the coupon code has already been used||Can be any numeral value||10|
|is_rss||Public In RSS Feed. Defines if the Cart Price Rule should be published in the RSS feed||0 – no, don’t publish Cart Price Rule
1 – yes, publish Cart Price Rule
|coupon_type||Coupon. The type of the coupon code:||1 – no coupon code
2 – specific coupon code
|use_auto_generation||Use Auto Generation. Defines if the coupon codes should be automatically generated for this Cart Price Rule||0 – don’t use auto generation
1 – use auto generation
|website_ids||IDs of the websites the Cart Price Rule is applied to||Website ID value||1|
Now that you have all cart price rule attribute reference you can use them to compose your own import table or use Google Sheet sample table.
Importing Magento 2 cart price rules
The import table is ready either it is a sample, not it’s high time to proceed with learning how Improved Import and Export extension works.
If you decided to stick to sample Google Sheet table keep in mind that all the coupon codes are set as disabled there.
If you want sample rules to be enabled – change the value in the is_active column to ‘1’.
Step 1: creating the job and general settings
The import jobs introduced by the extension can be found under System > Improved Import / Export > Import Jobs. Here you will find an import job grid where you can manage all the created import jobs.
To create a new import job click ‘Add New Job’ button. At the New Job screen you will be greeted by the General Settings section.
Here, you will need to enable the job. Name it to identify it later in the grid. Decide if the job should run every set period or manually. And select the locale of the store you are importing coupons to. When done – scroll down to the next configuration section.
Step 2: setup job behavior and source
Below the General settings you will be asked to select the entity you are importing. We are importing Cart Price Rules, so let’s stick to it.
Below the Import Settings nested Import Behavior section.
At the Import Behavior you select what the extension should do with the data from the import table. As of version 2.1.2 you can only ‘Add’ cart price rules to the store.
In addition to the behavior you will need to select validation strategy and adjust field and multiple value separators. The separators may come in handy if you are using different from recommended import table formatting.
Now we only need to select the source from where the extension should fetch the import table.
Step 3: select import source
The last job setting will be to select the import source.
Here, you need to select the file format of the table. The extension supports either XML or CSV tables. Select where the table if located. At the screenshot above we have selected Google Sheet and pasted the link. And, at last, hit ‘Validate file’ button to let the extension ensure the table is properly formatted.
Use Image Import Source is only used for product import and will not be required while importing cart price rules.
Step 4: save and run the job
Now the job is ready the only thing you are left to do is hit ‘Save & Run’ button at the top right corner of the screen. Then, in the popover page hit ‘Run’ button. The extension will do the rest.
Once the button is hit the extension will perform the import procedure and provide you with the log file where you can check how the job went. If required you can find the log file at your store FTP: var/log/firebear.
That’s it. You have just learned how to import Cart Price Rules to your Magento 2 store. If you require instructions on how to import other entities such as products, categories or CMS pages, read the dedicated blog articles.
Cart Price Rule Import & Export FAQ
Let’s take a look at other nuances of importing and exporting cart price rules and coupon codes in Magento 2 with the help of the Improved Import & Export Magento 2 extension.
How to import and export cart price rules and coupon codes to Magento 2 automatically?
Use the Improved Import & Export extension to import cart price rules and coupon codes to Magento 2 automatically on a regular basis. While the default import and export tools don’t support automation, unless you use Adobe Commerce, our extension utilizes a cron scheduler to automate these and other data transfers. As a store admin, you get the ability to import and export cart price rules and coupon codes between Magento 2 and external destinations automatically after specifying a schedule of updates.
How to import cart price rules and coupon codes with third-party attributes to Magento 2?
If a table with cart price rules and coupon codes contains third-party attributes, you no longer need to edit it manually before the import. The Improved Import & Export extension lets you create a mapping scheme where you match third-party attributes and values to ones used within Magento 2. As a result, any external data, including cart price rules and coupon codes, is easily adapted to the native Magento 2 standards. When it comes to export processes, you can also apply mapping to them, creating the output your partners require.
How to import and export cart price rules and coupon codes to Magento 2 via API?
The Improved Import & Export Magento 2 module provides the ability to transfer cart price rules and coupon codes along with other entities via API. You create API connections for transferring data to and from Magento 2 straight in the module’s import/export jobs. Specify the parameters necessary to sync the two systems right there.
How to import and export cart price rules and coupon codes to Magento 2 via ODS files?
Magento 2 works with CSV files only, but you can still move cart price rules and coupon codes in ODS files or export data using this format with the Improved Import & Export module.
How to import and export cart price rules and coupon codes to Magento 2 via XLSX files?
Magento 2 works with CSV files only, but you can still move cart price rules and coupon codes in XLSX files or export data using this format with the Improved Import & Export module.
How to import and export cart price rules and coupon codes to Magento 2 via JSON files?
Magento 2 works with CSV files only, but you can still move cart price rules and coupon codes in JSON files or export data using this format with the Improved Import & Export module.
How to import cart price rules and coupon codes to Magento 2 via compressed files?
If your files with cart price rules and coupon codes are compressed, use the Improved Import & Export module to transfer them to Magento 2. Remember that your file archive should be saved as a ZIP or TAR file, containing CSV, XML, ODS, JSON, or XLSX.
How to import cart price rules and coupon codes to Magento 2 from Google Sheets?
If cart price rules and coupon codes are stored in Google Sheets, use the Improved Import & Export extension to get them out of there and move them to your e-commerce website. It is only necessary to specify the address of the corresponding Google Sheets table. You can also export cart price rules and coupon codes from Magento 2 to Google Sheets with the help of our module.
How to import and export cart price rules and coupon codes between Magento 2 and Dropbox?
The Improved Import & Export extension provides the ability to transfer cart price rules and coupon codes between Magento 2 and other destinations using Dropbox as an intermediary platform. You can transfer CSV, JSON, XML, ODS, or XLSX files or ZIP and TAR archives.
How to import and export cart price rules and coupon codes between Magento 2 and Google Drive?
The Improved Import & Export extension also enables you to import and export cart price rules and coupon codes between Magento 2 and Google Drive via CSV, JSON, XML, ODS, or XLSX files. Note that they can be compressed as ZIP or TAR archives.