Import Metadata Adjustments

Navigate to Classified Order Setup -> Classified Tree Setup and then select the option on the left navigation for Metadata Adjustments Import.

1. If the import template is ready, click Select button to navigate to and choose the file you wish to upload. See below for Import Template field descriptions

2. If the import template is not ready, download the template and see below for instructions for filling it out

3. Click the test import file button to import in test mode to see if there are any errors.

4. If there are any errors, click the X to remove the uploaded file from the import, and then navigate to the file on your computer. Open it in excel and fix the data row causing the error. Re-save the file and then start again with Step 1.

5. When all errors are fixed and you have a successful test, click the import file button to import for real.

Import Template

If this is a new import, select the download template option to download a blank template. The fields can be filled in as follows:

Field	Example	Description	Mandatory?
Category Tree ID	LEGAL	This is the Category ID from the Category Tree Setup	Yes
Metadata Field	Photo	This is the Label/Question Field from Category Metadata Setup	Yes
Group ID	ALL	This is the Product Group ID. This is used if the intent is to import this into the "Metadata Adjustments by Group" setup	EITHER this field OR the Product ID field must be filled in.
Product ID	NAVTIMES	This is the Product ID from Product Setup. This is used if the intent is to import this into the "Metadata Adjustments by Product" setup	EITHER this field OR the Group ID field must be filled in.
Qualifier	A specific value	Options here are "A specific value" or "Not Blank" - same as onscreen options.	Yes
Specific Value	ABC	Alpha-numeric answer to the metadata field question	Only necessary is the above answer is "A specific value"
Adjustment ID	5	This will look at the numeric ID Adjustment, which is best seen on the Metadata Adjustments by product (or group) screen. We will add the ID to the Adjustment setup screen, but currently it is only showing the sort ID - which may or may not be the same as the sort.	Yes
Application Rule	Apply to First Insertion	Options for this - blank (means Apply to All Insertions) Apply to First Insertion Apply to Last Insertion	No
Allow Delete	Y	use Y for yes Blank or N for No	No