Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Show Table of Contents

Import affiliate products with WP All Import

We do offer a bulk import feature for products, but it has some limitations. The more comfortable way is to use WP All Import. This also requires extension for WP All Import.

In order to make an import, you need a unique product ID or EAN. On Amazon, this would be the ASIN. Without a list of IDs, no import can be made.

In our case, we will simply import some products from Alternate. Whereby we pass here only the relevant fields. The remaining product data will then be added independently by affiliate-toolkit.

Prepare import list

In our case, we use an Excel list here. We have copied these products from the data feed of AWIN.

We will now import this Excel list as products into affiliate-toolkit.

Create new import in WP All Import

Here you then select "Upload file" and choose "Products". Attention: Depending on which plugin you have installed, there may be several products here. Like e.g. also with WooCommerce products.

Then check the import file using Review. Mostly you can click here directly further.

Link fields

Then you link the fields that you want to take over.

In our example we set the product title, unique ID, EAN, category and product status. Also, we mark the product that it is a WooCommerce product.

How to find the store ID for your products:

The field for "atkp_product_iswoocommerce" is optional. This is only necessary if the product will be copied to WooCommerce later. You can just leave it out.

The field for the EAN is also not a required field.

The "asintype" can have an ASIN, EAN or a TITLE as value. Depending on the selected type, the corresponding title must then be entered in the "asin" field.

Which fields can I fill?

Basically you can "overwrite" all fields of affiliate-toolkit. That is, each field that is set overwrites the metadata. Whether product information or price.

Here is a list of system fields:

  • atkp_product_title
  • atkp_product_mpn
  • atkp_product_productgroup
  • atkp_product_manufacturer
  • atkp_product_author
  • atkp_product_numberofpages
  • atkp_product_brand
  • atkp_product_releasedate
  • atkp_product_description
  • atkp_product_features
  • atkp_product_iswoocommerce
  • atkp_product_producturl
  • atkp_product_addtocarturl
  • atkp_product_customerreviewsurl
  • atkp_product_rating
  • atkp_product_reviewcount
  • atkp_product_predicate
  • atkp_product_testresult
  • atkp_product_testrating
  • atkp_product_testdate
  • atkp_product_pro
  • atkp_product_contra
  • atkp_product_smallimageurl
  • atkp_product_mediumimageurl
  • atkp_product_largeimageurl
  • atkp_product_listprice
  • atkp_product_amountsaved
  • atkp_product_percentagesaved
  • atkp_product_saleprice
  • atkp_product_baseprice
  • atkp_product_baseunit
  • atkp_product_baseunits
  • atkp_product_availability
  • atkp_product_shipping
  • atkp_product_isprime
  • atkp_product_iswarehouse

For custom fields we recommend creating custom fields via our extension or directly via Advanced Custom Fields.

Confirm & perform import

In the next step we now confirm the import of our products.

Products are successfully imported

With the import, all products have now been created. These products are of course without picture, price or other information. This import is done by affiliate-toolkit itself.

Here you can still see the detailed view of a product:

You can see that the store and the product IDs have been assigned correctly. And below it is also indicated that the product will be updated with the next update.

The corresponding hook for WooCommerce is also set:

Update products through affiliate-toolkit

Either you wait until the system automatically updates the products in the background or you start the whole process manually.

For the manual way we click into the settings and change the cronjob type to "External with output".

The time window should of course be configured for our current time. Since otherwise no update will be performed.

We now copy the URL which is displayed below and paste it into the address bar of our browser. This call may take longer depending on the number of products, stores, etc. It may also be possible to abort the script. In that case, simply call again after 15 minutes.

Recommendation: Alternatively, simply configure a server-side cronjob. Then you do not have to do this by hand.

If successful, you will now get this output displayed in the browser:

After the procedure, be sure to reset the settings for cronjob type and time back to the original value!

Verification of the product data

In the queue you can also see that all products have been retrieved properly:

Here is the detail view:

If an error had occurred, the "Status" in this listing would be Error and to the right of the column you would see the error message.

In the overview you can now also see images and product data:

Updated: 6. February 2023
Still not using affiliate-toolkit?
Setup takes less than 5 minutes and you can start to import first products!
Learn more about the packagesDownload FREE Version
Still need help?
Submit Your Question
Please give us the details, our support team will get back to you.
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram