With Paperturn’s PRO subscription, you can add links in bulk to your flipbook using an .xls file. You can add either external links or product links, helping you save precious time and effort.
**Please note, the Bulk Link Import feature is only available with our Pro subscription. Neither our free 14-day trial nor our Basic subscription allows for access to this feature. This feature requires a lot of technical knowledge. Please have a technical member of your team assist when setting up this feature.**
Follow our steps below to get started!
STEP 1: SELECT BULK LINK IMPORT TYPE
(1.1) Select the flipbook you wish to upload bulk links to and click on the “BULK IMPORT” tab.
(1.1) Select the flipbook you wish to upload bulk links to and click on the “BULK IMPORT” tab.
(1.2) Select the type of links for your bulk import:
External links will redirect your viewers to a URL outside of the flipbook
Product links will add automatic product links to your products and work together with our Shopping Cart Feature. It is important to note that the shopping cart feature MUST be activated first if you choose this option.
STEP 2: DOWNLOAD AND FILL-IN THE .XLS TEMPLATE
(2.1) Download and view our .xls example template. The .xls file you upload must match our example template exactly (in terms of formatting & data input) for the upload to work.
(2.2) Download the blank .xls file template and complete by adding your relevant data.
Requirements when filling out your .xls template:
You must fill in the SearchText column. This is the only column that requires data for the feature to work. SearchText refers to the data that we will search for within your flipbook in order to add the relevant link. SearchText must be unique and must exactly match the text in your flipbook for us to accurately place your link (including spaces and special characters). For example, the product name in your flipbook is Porcelain Mug 21. Your SearchText in your .xls file must be Porcelain Mug 21. If you have a product number instead of a product name, it is preferable to use that instead. It is easier for our system to search for definitive numbers rather than names / characters.
SearchText should only be entered once. Even if the SearchText is displayed numerous times within your flipbook, it should only display once in your .xls document. There should not be two (or more) rows with the same SearchText. If there's two or more rows with the same SearchText in your .xls file, then they will not be imported.
Mouseover text refers to the text that will display when your viewer hovers their mouse over your inserted link.
External Links must include the full web address, starting with https://…
Product Links must not include a currency symbol in the pricing column - only the number with a comma as decimal point (ex. 99,95). You may select your currency option within the Shopping Cart feature.
You do not need to fill in every column (only SearchText is required).
There cannot be any empty rows in the .xls file - our system will stop searching as soon as it recognises a break in data.
STEP 3: UPLOAD YOUR COMPLETED .XLS FILE
STEP 4: CUSTOMIZE THE DESIGN & POSITION OF YOUR LINKS
(4.1) Choose which icon to display with the links, the size of the icon, the color of the icon and the location of the icon in relation to the SearchText. You can also choose not to display an icon (‘none’) and the link will be inserted directly over your SearchText.
(4.2) When you’re finished with customization, click “IMPORT LINKS”.
STEP 5: REVIEW YOUR BULK LINK UPLOAD RESULTS
(5.1) Once your .xls file has been successfully uploaded, Paperturn will give you an overview of where your links have been inserted.
(5.2) If you’re satisfied with your results, click ‘save.’ Your bulk links will now be added and active within your flipbook.
If you’re not satisfied with your results, select ‘cancel’ to remove your file. From here, you can adjust the SearchText on your original .xls file and reupload the amended file to view new results.
AD YOUR COMPLETED .XLS FILE
How to edit & remove your bulk links
HOW TO CHANGE ALL BULK LINKS: Visit the “BULK IMPORT” tab on the corresponding flipbook, edit your icon display options and click “SAVE CHANGES”. This will apply your changes to all links uploaded via the bulk link import. CHANGE ALL BULK LINKS: Visit the “BULK IMPORT” tab on the corresponding flipbook, edit your icon display options and click “SAVE CHANGES”. This will apply your changes to all links uploaded via the bulk link import.
HOW TO REMOVE BULK LINKS: To remove all bulk imported links, simply click “REMOVE ALL BULK IMPORTED LINKS”. This will permanently remove all bulk imported links from your flipbook (links that were added individually using Paperturn’s editor will not be removed).
HOW TO CHANGE INDIVIDUAL LINKS: If you’d like to individually adjust, add or delete a few bulk links, follow the steps in our help guide on how to insert links in your flipbook.
* Please note: This is a technically complicated feature. Links may not, in some circumstances, transfer perfectly when we convert your flipbook into an HTML page (we do this in order for us to accurately locate your SearchText). In this case, you can use Paperturn’s editor to manually add any missing links and adjust the placement of those links that have not transferred perfectly.
You can only upload ONE .xls file per flipbook.
After the import is complete, please wait a few minutes before viewing in your flipbook. The links can take a short while to load.
