Importing Order Status File with Custom fields

Navigation

STEP # 01: Upload Your CSV File #

Go to your website and under main menu click on All Import ->  New Import.

 

 

 

 

 

 

 

 

 

Upload File

STEP # 02 #

You will be directed to the below page. Here you can choose to upload the file from your computer, paste in a URL to the file, or choose an existing file that you’ve already used with All Import tool.

 

 

 

 

 

 

 

 

STEP # 03 #

After uploading the file, you have to choose from one of the two options:

  • New Items -> Create only new items.
  • Existing Items -> If you are importing data from your file into posts that are already in your site, select Existing Items.

Step # 04 #

Finally, you need to decide what you want to import, select the desired option from the dropdown and press the continue to Step 2 button.

 

 

 

 

 

 

 

 

Review your Data

STEP # 05 #

All Import tool will process your file and prepare it for import. If you uploaded a CSV, check that the correct delimiter was used. If you uploaded an XML file, check that the correct node was selected.

If you only want to import some of the records in your import file you can add filter rules.

Click on Continue to Step 3.

 

 

 

 

 

 

 

 

 

Configure your Import

STEP # 06 #

Every column or element from your import file will be displayed on the right. On the left you have your import. All Import tool will create posts using the import template you create here. Simply drag your import data from right to left. You can fill in as much or as little of the fields as you like depending on your needs.

  • Order Details Section:

Add the order details if you wish to update from the CSV file you have uploaded by dragging and dropping in the fields below

 

 

 

 

 

 

 

 

 

Order items:

Provide the order item details . You can also manually import product order data. See the image below.

 

 

 

 

 

 

 

 

 

  • Custom Fields Section:

To find meta keys for entering in the custom fields.

    1. Go to your website.
    2. Toggle menu and under Order Manager open Custom Order Fields.

 

 

 

 

 

 

 

 

 

The meta keys for each admin custom order field are in the format of _wc_acof_{id} where {id} is replaced by the integer id of the field. Copy the id’s clearly visible next to the label of each field as shown in the image below.

 

 

 

 

 

 

 

 

 

 

Now Paste the ID’s of Logistic, CN and BIS numbers that you have copy in the previous step into the fields shown in the image below. Follow the same format of meta key that we have described in the previous step.For example the meta key for the logistics would be based on its ID is _wc_acof_2

Note: If you are using IMPAKTT order shipment solution, make sure to add order_weight in custom field, and bind it with import sheet order weight column.

Click on Continue to Step 4.

 

 

 

 

 

 

 

 

 

 

 

STEP # 07: Choose Which Data to Update #

Here you can tell WP All Import how to handle each specific piece of data.

In the last step you have to specify the unique identifier in order to match the existing items.In this image shown below, the chosen unique filed is Order ID

 

 

 

 

 

 

 

 

You can also use custom field for this. Just enter the name and drag its value in the field from the table on your right. Keep in mind that it should be a unique field.

 

 

 

 

 

 

 

 

 

Click Continue to proceed to the next page.

Step # 08: Run Import #

Click Confirm & Run Import to run your import.

 

 

Powered by BetterDocs

Leave a Comment

Schedule your meeting
with team IMPAKTT today!

Our team will get in touch with meating details and schedule within 48 hours.

One Step Away From A Digitized Society