1. Home
  2. ReHub Theme
  3. Affiliate settings
  4. Bulk import of offers

Bulk import of offers

Theme has import extension for plugin WPAI. You can use Free version of plugin which you can download from wordpress.org. All our Addons will work with Free version of plugin. Any of xml or csv file which you can get from your affiliate network can be used for bulk import.

We provide several addons, each addon is made for special type of site and functions.

Bulk import of Deals, coupons

This type of site means that you will have only single Main offer in each of your post. You can check example of such site on recash.wpsoul.net demo.  Offer can be added as simple deal or as a Coupon. You will need WPAI plugin and Post addon.

We provide Post addon which you can download from Rehub – Plugins

Before import to posts, maybe, you will need to create separate Store pages for your offers. Example If you need this – enable option to create store pages 

After installing WPAI plugin and our addon, go to All import – Import and upload xml/csv file or provide direct link on file. It will be better if your affiliate network provide auto updated link to file with all offers. In this case you can create also price updates and keep your deals actual.

After uploading, you need to choose where to import your feed. Choose “Posts” and go to next step. Second step will show you structure of your imported file. I always skip this step and go to Step 3. Step 2 is useful only if your file has very complex structure and you want to choose only special part of file to import.

In Step 3 – you must map each of field in your import file to WordPress fields.

In right part, you will see all available data of your import file. You can drag-n-drop all fields to the proper fields in left part. In my case. I can drag-n-drop field Title to Title field in left part and Content to Content field.

Next Block is Image. Free version of WPAI Plugin doesn’t have option to upload Post image, but you can upload image url in Post Offer section

For this, enable option “Download image hosted elsewhere” and drag to this field image url field.

In many coupon feeds, your feed will not have image at all. In this case, you can show Image logo of your store (you can assign store while import). Use extension to show brand logo if your post doesn’t have image

Let me explain other fields in Post offer section.

Post offer Name and Short description can be useful if you want to assign different description for your offer block from Main title and content of Post. But usually, I leave this field as empty.

Offer sale Price and Offer Old price – if you have just one price in offer, set it to Offer sale price. If you have two prices (regular and discount), set current price in sale price field and old price in Old price field

Button Text is useful if you want to add custom text to button of offer. For example, if you import all products from Ebay, you can change button to “Buy on Ebay”. Leave blank if you want to have “Buy this item” text. You can also change all Button text globally for all posts in theme option – localization.

Store Logo Url, Store name – If your feed has also logo for Store/Merchant, you can assign logo here while import. Also, you can assign logos to after your import. Go  to Posts – Affiliate Store  , edit your stores and assign logos to them, as well as descriptions. You can also auto create stores while import. For this, attach name of merchant/store to Store name field, then, open Block Taxonomies, Categories, Tags and attach the same store name

Offer currency – here you can place currency code in  ISO 4217 You need to do this only if you want to have schema type as Product in google. This can help to get advanced snippet in google with price, like this

But there is no any guarantee that you will have it.

If you need to add coupon to deal, you can do this in Post Coupon Section

Here you can add coupon code, expiration date and enable “reveal coupon” function. Theme uses dates in format yyyy-mm-dd, sometimes, your feed will have another structure of date, so, you can enable converting.

Mask coupon code – You can enable this option if you want to hide coupon. So, user must click on button to show coupon. Original site will be opened in another window, so, in this way you can be sure that you will get commission. Without this option, coupon will be visible for all and users can just copy coupon and leave your site.

Rehub Location and Rehub Post Review can be used if you want to add Reviews to post and and location.

Post Layout

Post Layout – while import of deals, you can choose also our special post layouts which are made special for offers. I don’t recommend to do this if all your posts will be for coupons. Because, you can set global Post layout in Theme option – general option. So, use this block only if you want to set special post layout for imported posts. Here, we mark post layouts which can be good for Deals and Coupons

After mapping all field, go to next step

Here you can set how to handle your recurring import. Click on Auto-detect button. Usually, it will detect your title field. So, this will add unique ID which will be equal to title or other field which you want. In next time, if plugin find any post with the same ID, it will detect it as existing post. Then, you can choose what to do in such case: update data of post, delete other posts and you can choose what to update. Usually, I choose to update only Custom fields, because theme saves all prices, coupons and other data in custom fields.

How to combine offers from several networks or update existing prices

For example, you have two feeds and one product feed can have similar offers and you want to combine them and get only unique deals from each file. Most important part for this is common ID in your feeds. This can be SKU, ASIN or even title of product. So, you make first import as always, but, on Step 3, when you make mapping, place your identification code also as Custom field with any new name, for example, “sku”

Now, when you do another import with new feed and you want to combine them, make import NOT AS NEW POSTS, but as “Import To existed Posts”

Also, save your identification code to the same custom field as previous time

In last step, before making import, you will see option to detect duplicates base on your fields. Choose your custom field where you stored your ID

Also check option to add new posts if plugin will not find ID. Also, you can click to update data of existed posts (for example, if you want to update prices from new import and overwrite existed offers with new one)

Price comparison feature with bulk import

For example, you have feeds from several affiliate networks or merchants and you want to compare prices for the same product. This is possible with unique addons of our theme, but only one requirement – all your feeds must have any common part to group the same product. It can be SKU, EAN, title or even link. But it must be identical in different feeds for the same product. If you don’t have such common part – you can’t make price comparison, so, you can make only deal/coupon site. If you have such ID in your feeds, you can import your deals with our Woocommerce addon or with our Content Egg addon.

There are some difference between two addons. When you import by woocommerce addon, each of your offer will be posted as separate Product, then combined by our theme by SKU field. Theme will choose lowest price product and will hide all other products for the same deal. Content Egg addon will post all offers inside one product, this is better because you will have less products on site and you will have more layouts for output and flexibility, you can assign more offers manually after import. So, I recommend to use Content Egg addon for any kind of affiliate price comparison site and our Product addon if you need Multi vendor site or you need to have separate products for each offer. Let’s start from Content Egg addon.

Content Egg addon for bulk import and price Comparison

First of all, install Woocommerce and Content Egg (from Rehub – Plugins tab). Free version of Content Egg addon which is bundled with theme is enough, but we recommend PRO version if you need more functions and modules. Next, Enable Offer module in Content Egg settings. Also, enable saving Featured image of post in settings of Offer module.

Enable also “shortcode only” option to prevent adding offers automatically in end of product. Then, go to Content Egg – settings – general settings and enable Woocommerce synchronization

Now, you need to install WPAI plugin (PRO or Free) and Woocommerce Addon + our Content Egg addon.

This kind of import doesn’t require PRO version of plugin, so, you can use free versions.

WPAI free

WPAI woocommerce addon

However, if you want to have access to import from link, import to external products or simply want to have full version of WPAI, you need to send us special request as mentioned in beginning of this post

Additionally, you must install CE addon and Post Addon for WordPress All import. You can get Content Egg Rehub Addon in Rehub – Plugins tab, install and activate both addons and plugin.

Next, import your file or url and select import as Woocommerce Products in first step of import:

On second step, map your Title and Content Field to Proper field of Woocommerce product. Leave prices and everything as blank. Move to Content Egg offer section. All fields in this section is the same as you have in Offer module when you manually create product:

By the way, WPAI plugin supports “drag-n-drop” technology:

Don’t forget, that it’s better to set deeplink and offer url as separate fields if this is possible. For example, if you have offer url as http://amazon.com/product/2222?tag_id=2342, where tag_id=2342 is your Affiliate ID (usually, it has name “deeplink), you must add  http://amazon.com/product/2222 to your offer url field and tag_id=2342 to deeplink field. This is not required, but we recommend to do this.

NOTE. To have merchant logo front-end you must use exactly deeplinks then CE plugin will retrieve logo from Product URL.  If you will use Affiliate network URL then you get its logo. But Content Egg Rehub Addon has one trick which works only with Content Egg Pro plugin:

you should to paste Merchant Domain during the first import. After this the plugin will retrieve the merchant logo from this domain. This trick acts only once and can not be updated in the future.

Now, most important part if you need price comparison and proper updates is Unique Post ID:

In this field, add your common part from your feeds. Usually, it has name SKU, EAN, ASIN, product ID, etc If two offers from your feed will have this common part, plugin will not create new product and will attach new offer to existed product or will update existed offer.

Product Layout

While import, you can choose also our special product layouts which are made special for Content Egg. I don’t recommend to do this if all your products will be for Content Egg. Because, you can set global Product layout in Theme option – shop settings. So, use this block only if you want to set special product layout for imported offers. There are several Product Layouts which are better for Content Egg because they will have all Blocks enabled by default, so, you don’t need to set any special shortcodes to content. All of them have “Content Egg” in name of Layout. You can see demo for all layouts on rewise.wpsoul.net

Updating Existed Content Egg offers and adding new offers to existed products

Now, when you make another import with new feeds and you want to update offer’s price or add new offers, do next steps:

  1. Add new import as  import to Existing Items on first step
  2. Do all steps as usual
  3. On last step, set special key _ce_unique_pid as key for Matching

That’s all for Content Egg import.

Woocommerce Addon for Bulk import and Price Comparison

If you think that you need to have different products for each offer, you can use our Woocommerce Addon. If you need woocommerce addon – send us request This is available only for our clients (theme buyers).

Before importing products, install our Special Plugin RH Woo Tools in Rehub – Plugins.

Importing deals for price comparison is the same as for posts (see above). But you must import offers as Woocommerce Products

  1. Import your feed to woocommerce products
  2. While import, don’t forget to add unique ID from each offer item to SKU field of woocommerce products

Next thing, you must use one of available special product layouts if you want to have support for price comparison. We provide two layouts for this. You can choose them for all products on site (globally) in theme option – shop settings – shop layout or when you make import.

Price Comparison Layout with shortcode

First product layout has name Compare prices by shortcode. It has next look

This product layout is made for multivendor products, but you can also use it for products which are imported by bulk import with some shortcode. You must add shortcode

[wpsm_woocompare field=_sku logo=product]

to  Theme option – shop option – code zone near button 

This area is global area (will be added to all products on your site. If you want to add it only to imported products, add shortcode while import to custom field with key rh_code_incart

If theme will find any other product on your site with the same SKU, it will group all such offers in this common Product Hub. In other words, theme will show all offers with the same SKU in each product.

By default, theme will show logo of products, but you can also create separate Merchant/Brand pages and show Store logos. For this, while import, attach your “Brand” in Taxonomies, Categories, Tags section.

Brand is just name, you don’t need to use real brands there, you can use this part also as Merchant/Store pages. You can assign logos to each Brand in  Products – Brands – Edit 

Then, if you want to show these logos, use “brand” instead “product”. Final shortcode will be

[wpsm_woocompare field=_sku logo=brand]

You can also use custom fields as titles in product list (by default, it shows product title). For this, while import add merchant name to any of your custom fields, for example, with key “product_merchant”. Then, use next shortcode

[wpsm_woocompare field=_sku logo=brand titlefield=product_merchant]

So, instead product title, you will have custom title in list which will be added from your custom field “product_merchant”

Price Comparison List Layout

Another Product layout which was added recently is Price list layout. You don’t need to add any shortcodes if you choose this Product layout, because it will grab products by sku automatically. Product layout has name Compare Prices by sku. It has next look.

Price updating option to update existed products are the same as for Posts which we described above. The only difference is that you can use key “_sku” as matching key in settings. This key is used by wordpress to store SKU.

Hide duplicated products

After importing products with the same SKU, you will see that you have duplicated products on site. Each of this product will have price comparison list. But you can hide them from site and make visible only product with lowest price. For this, Install our plugin RH Woo Tools (You can get if from Rehub – Plugins). After installation, go to Woocommerce – Status – Tools. In end of page, you will find option “Hide duplicated products” Click on it and all duplicated products will be hidden except products with lowest price.

Link Cloaking

If you make Bulk import to posts and want to cloak offer links, use our RH Link Offer Cloaking. You can get it from Rehub – Plugins – Bonus plugins

If you want to cloak woocommerce links – use Plugin

If you want to cloak links of Content Egg offers, you can enable  Redirect  option in settings of each module of Content Egg

Recurring import

If you need Price update, you will want to use Recurring import. It will be best option if your network provide always actual link on feed, in this case, you don’t need to upload new files each time and you can use simple Re-run from time to time (cron is also possible). Check this article