Bulk Import
Importing a large number of postal codes via CSV upload
The
Add New Postal Code method works best for adding limited number of postal codes, or to perform incremental updates, or modify existing pincodes. However, if you have a large number of postal codes, the best way to move forward is to use the Bulk Import. The Bulk Import steps are demonstrated in this section.
First, open the Bulk Import tab and download the Sample File
First, open the Bulk Import tab and download the Sample File
Once the CSV sample file is downloaded, you can populate the fields as demonstrated below.
Do not change the first row of the CSV file. Changing this can cause import errors.
As the first step, add postal code, country, state and city, one per line.
The products column permits you to either allow or block specific products for this postal code. If you would like to allow all products for this postal code, leave the column empty.
To allow specific products for a postal code enter Product IDs separated by the pipe delimiter "|" (the pipe delimiter is customizable in the import page) in the products column, and in the product_status column, enter allow. To block them, enter block in the product_status column. Alternately, you can also use SKUs instead of Product IDs.
The shipping_methods column permits you to either allow or block specific shipping methods for this postal code. If you would like to allow all methods for this postal code, leave the column empty.
To allow specific methods for a postal code enter the Method IDs separated by the pipe delimiter "|" (the pipe delimiter is customizable in the import page) in the shipping_methods column, and in the shipping_method_status column, enter allow. To block them, enter block in the shipping_method_status column.
You can find Method IDs listed under the Shipping Methods section of the import page
The payment_gateways column permits you to either allow or block specific payment gateways for this postal code. If you would like to allow all gateways for this postal code, leave the column empty.
To allow specific methods for a postal code enter the Method IDs separated by the pipe delimiter "|" (the pipe delimiter is customizable in the import page) in the payment_gateways column, and in the payment_gateway_status column, enter allow. To block them, enter block in the payment_gateway_status column.
You can find Method IDs listed under the Payment Gateways section of the import page
Open the file, and start filling out the columns, which are explained as under:
The bulk import file is now complete. The final step in this process is to import it into the plugin. Click Browse at the top of the import page, select the CSV file, and click the Upload File & Import button at the bottom.
Please be patient! Depending on the number of postal codes in the file, it could take up to a few minutes to process.
That's it! You're all done. To make sure the import was successful, navigate to: WooCommerce > Zip/Pin/Postal Code Validator. You should see all the imported postal codes listed under the Postal Codes tab.
Last modified 2yr ago