LogoLogo
Online GuideTutorials & GuidesNewsNetset PDB
English (original)
English (original)
  • Welcome
  • Online Guide
    • Dashboard
      • Supplier Status Widget
      • Purchase Orders Widget
    • Orders
      • Orders
      • Purchase Orders
      • Create Combined PO (EOL)
      • Invoices
      • Uncompleted Orders
      • Returns
      • PunchOut - ADD-ON
    • Products
      • Products
      • Bundles
      • Focus Assortments
      • List of Products
      • Suppliers
      • System Suppliers
      • Supplier Import Logs
      • Manufacturers
      • Product Range Limitations
      • Product Range
      • Product Variations
      • Supplier Import Filters
      • Flags
      • Top Sellers
      • Warehouses - ADD-ON
      • Weight
      • Product Forms - ADD-ON
      • Product Notification
      • 1WorldSync SKU
      • Configurators
        • Aurdel Cable Guide
      • Expired Products
      • Product Option Groups - ADD-ON
      • Product Options - ADD-ON
      • Asset Inventory - ADD-ON
    • Shipping & Delivery
      • Shipping Matrices
      • Delivery Options
      • Delivery Sites
      • Category Settings
      • Supplier Settings
      • Geographical Areas
      • Shipping Test
    • Marketing
      • Promotion Items
      • Promotion Pages
      • CMS Pages
      • Front Page Sections
      • Menus
      • Page Footer
      • Page Header
      • Vouchers
      • Mail Forms
      • Documents (EOL)
      • Search Linking
      • Image Overlays
      • Additional Product Text - ADD-ON
      • Product Tags
    • Categories
      • Categories
      • Category Groups
      • Business Area - ADD-ON
      • Accessories
      • Product Menu Settings
    • Pricing
      • Price Logics
      • Rounding
      • Price Level Naming
      • Fixed Price Editor (EOL)
      • Fixed Price Lists
      • Price Logics Groups - ADD-ON
      • Bids
      • Price Test
      • Global Bids - ADD-ON
      • Cost Price Strategies
    • Customers & Users
      • Customers
      • Users
      • Customer Groups
      • Customer Segments - ADD-ON
      • Administrators
      • Sales Teams - ADD-ON
      • Resellers
      • Permission Profiles
      • Merge Customers
      • Single Sign on - ADD-ON
    • Payment Options
      • Payments
      • Payment Option Groups
      • Payment Providers
      • Taxes
      • Currencies - ADD-ON
    • Quotes
      • Quotes
      • Quote Requests
      • Quote Templates
    • Email
      • Email log
      • Mail Lists
      • Grabbed Emails
      • HTML Email
      • Email Templates
      • Mail Server
      • DKIM
    • Imports
      • Imports
      • Order Imports - ADD-ON
    • Exports
      • Exports
      • Single Object Exports
        • XML Sales Order
        • XML Purchase Order
      • Products Exports - ADD-ON
    • Statistic
      • Login Statistics
      • Active Users
      • Sales Statistics
      • Retailer Statistics
      • Product Statistics
      • Customer Group Statistics
      • Customer Statistics
    • Settings
      • Settings
        • 1WorldSync Logo Services
      • Admin Settings
      • Contact Info
      • Cookie Banner
      • Countries
      • Domains
      • Extrinsic Fields - ADD-ON
      • Files
      • Form Editor
      • Google Analytics
      • JavaScript
      • Languages - ADD-ON
      • Next Invoice Number
      • Next Order Number
      • Notifications
      • Order History Search
      • Order Status
      • PDF
      • Password Policy
      • Responsive Profile
      • Search Tuning
      • Translations
    • End of Life Features
      • Newsletter Email
      • Templates for Newsletters
  • Tutorials & How-to
    • Authentication and Security
      • 2-Factor Authentication
      • SPF Setup Instructions
      • DKIM Setup Instructions
      • reCAPTCHA Setup Instructions
    • Workflow and Process
      • Approval Process
      • Exports
      • Imports
      • Log in as an Customer/User
      • Setting up a Discount Using "Discount on General Price".
      • Project Database, PDB, Onboarding Manual
      • Dynamic HTML - ADD-ON
    • Techical Setup
      • Avalara Tax Calculator Setup Instructions
      • Google Analytics 4 Setup Instructions
      • URL Setup Instructions
    • Product Management
      • Alternative Products
      • Lists of Products - LOP
      • Focus Assortment
      • Setting up Display Categorys - ADD-ON
      • Asset Inventory - ADD-ON
    • Tips and How-to
      • How a Product is Identified in Nettailer.
      • How to benefit from Extrinsic fields & Product form.
      • Test order Delivery to ERP-Integration?
      • Keyboard Shortcuts for Administration Users
      • Markup vs Margin
      • Address Handling
      • Order Status
      • Using "Privacy Mode"
  • Explore add-ons for Nettailer
    • Orders
    • Products
    • Marketing
    • Categories
    • Pricing
    • Customer & Users
    • Payments
    • Quotes
    • Integrations
    • Settings / Other
  • Current Suppliers
  • Security & Accessibility
    • Accessibility requirements
  • News
    • Nettailer release 25.1
    • Nettailer release 25.0
    • Nettailer release 24.6
    • Nettailer release 24.5
    • Nettailer release 24.4
    • Nettailer release 24.3
    • Nettailer release 24.2
    • Nettailer release 24.1
    • Nettailer release 24.0
    • Archive
      • Webinar March 20th 2024
Powered by GitBook

Netset AB

  • Adelgatan 9
  • 211 22 Malmö
  • Sweden

Project database (pdb)

  • >> Create a support ticket

Get in touch

  • netset.com
  • support@netset.com
  • +46 40 20 88 00

Copyright © 2025 Netset AB all rights reserved.

On this page
  • Accessories import
  • Address import
  • Product Imports
  • Fixed-price imports
  • BID Imports
  • Customer Import
  • Image Import
  • Warehouse Stock Imports
  • Agreement assortment product import
Export as PDF
  1. Online Guide
  2. Imports

Imports

Last updated 8 months ago

In this section you can import your own data or images to the shop. There are different options and you can download the Excel templates, sample files and instructions for each type of import.

Accessories import

This import is used when you want to connect accessories to products.

Supported format: Excel file (XLSX).

Template structure:

Template explanation:

Title
Meaning

Main part number

Product article number.

Main manufacturer name

Product manufacturer name.

Accessories part number

Product article part number of the accessory.

Delete

If the accessory should be deleted from the product.

Recommended

If the accessory is recommended.

Address import

This import is used to update customer addresses.

Supported format: Excel file (XLSX).

Template structure:

Title
Meaning

Action

Delete column: column is used to delete an existing entry by filling in "D". It should be left blank otherwise.

Address type

The Address Type column should contain 0 for Invoice address or 1 for Delivery address. Any other value, or an empty row, will cause the row to be skipped.

Name

Company

Gln

Address 1

Address 2

Zip

City

Country

Code

The Code column is for identifying specific addresses on the customer, if a customer has multiple addresses each of them need a unique Code to be separated from the other addresses connected on the customer. If no address is found via the code then a new address will be created on the customer(s).

Read only

The "Read Only" column should contain either the value "true" or "false". If set to true, this address will be set as read only and can not be modified in the shop. It can still be changed or deleted through a new import.

Customers

The Customers column should contain comma separated customer numbers to be updated with the address.

Product Imports

If you wish to extend the solution range of complementary products, there are procedures in place. Select the type of product imports. After that you can, via the option "Download template for Excel-import", download a zip file containing an Excel template that is based on a given product structure. The Zip file also contains an example and a description of the columns in the template.

Fill in the Excel template with the products you wish to replenish. The next step is to upload the Excel file.

Next, use “Browse” to search for and select your file. Once you find the file to be imported, click on the button "Execute the import."

Please note: You cannot make any structural changes in the Excel template, for example. You cannot delete or add columns, however on some occasions you may not have to fill in all columns with data on the template. Binding columns marked with an asterisk (*).

Fixed-price imports

This type of import is to be used in the event that you wish to administer fixed rates via Excel. This is useful in the event that you wish to work with a larger number of fixed prices. Imports constitute real price logics within the shop. If necessary you can edit imported fixed price logics using the same sheet.

BID Imports

This import is used in the event that you wish to complete the shop with BID pricing. This can be useful if for some reason you cannot obtain your “price file” with associated purchase prices automatically.

Customer Import

Here, you can import customers with associated information such as shipping and billing addresses. You can also add the price file and other additional connections that the customer needs to be associated with.

If you do not want an email to go out to newly registered customers once they have been uploaded please ensure that the “Registration Mail to new customers” is unchecked.

In this part you can also create your own dynamic template. At "Dynamic field template", click on Edit / Create and then select the fields you want to be in the template.

When you are done, click Ok and then select the template you created. Note that the columns in your excel file must have the same order as you created in your template.

Image Import

To import images in a coherent way you must make sure that the image is named the same as the manufacturer's part number, plus the file extension. (Jpg or Gif) Once you have collected the images you want to import into a folder, create a zip file of images in the folder. Zip the file to the upload by selecting the type; "Photo Import" during the import, and then use the “Browse” button to locate the file to be imported. Click on "import". The pictures will be treated to images sized to best fit into the store.

Warehouse Stock Imports

Import of own stock is done by imports. You can also choose which layer for the import if you have several warehouse locations.

Agreement assortment product import

Import products to an agreement assortment list. This can be very useful if you have a long list of products to add.

Function
What it does

Save import

This option lets you configure a recurring import via FTP. When the file is updated on the FTP, it will be scheduled for import in the shop.

Type

Choose the format of your import file. These are the options available to use.

File

Pick a file to upload.

Focus assortments

Choose the focus assortment to import to.

Full file import

If checked, the current focus assortment will be emptied and replaced with the products in the import. Otherwise, the current products in the focus assortment will be merged with the products in the new import.