Purpose and scope

The Product Administration section within Aphix Management Interface aids in maintaining product catalogue quality by providing you with a set of features that allow you to create, update and maintain your product data.

The purpose of this article is to describe how to use the custom product export to export my product catalogue.

Step by step

Step 1: Log into Management Interface

Log in

Log into Management Interface using your username and password. This opens the dashboard of your Management Interface.

Step 2: Open Product Administration

Open

Click Products on the left hand menu. This opens Product Administration, from where you can manage your product catalogue.

Select Export / Import from the group of buttons at the top of the Product Administration page. This opens the Product Import / Export page.

Step 3: Export category tree using Custom Export

Export
  1. Select Export tab. This opens a page giving you export options.

  2. Select Custom Export. This opens the Custom Export page, that allows you to select which fields in your product catalogue you can export to a spreadsheet.

  3. Highlight the fields you wish to export by left clicking your mouse and holding the ctrl key down. You must include Category Tree to export your category data.

  4. Click Export to export the data.

The product code is always exported and is the first column in the spreadsheet.

Step 4: Update category details in spreadsheet

Update

Open the downloaded spreadsheet. This has a specific format, as follows:

Column name

Code

Name

Brand

Range

Category Tree

Column description

Product code / SKU

Product name

Parent category in simple category tree

Child category in simple category tree

Existing category in category tree

Update spreadsheet as required.

Key points

  • We support two different ways of curating your category tree:

    • Standard category tree, where you can create multiple parents and children categories. Useful if you have a large range of products, and you want to add products to many categories.

    • Simple category tree, where you create a single parent with multiple children categories. Useful if your product catalogue consists of brands and models.

  • The spreadsheet has a pre-determined format, which must be used. If not, your categories may not import correctly. Read our troubleshooting guide on How is the category tree structured and how do I manage it? for some tips.

Save your spreadsheet.

Step 5: Import updated spreadsheet

Import

Return to the Category Management Configuration Tool.

Click Choose File under Categories Spreadsheet. This opens a file browser, from which you can select the updated spreadsheet.

Click Import Categories. This imports the spreadsheet.

  • Changes made to your category tree are visible immediately in Aphix WebShop.

  • The spreadsheet has a pre-determined format, which must be used. If not, your categories may not import correctly. Read our troubleshooting guide on How is the category tree structured and how do I manage it? for some tips.

Related articles