Control > Commerce > Catalogue Items Import

Use the [_null_] placeholder in Update mode to remove values from the desired fields.

The placeholder is allowed on the following columns:

• ProductLine
• ProductCategory
• AssociatedCatalogueItemCodes
• CatalogueGroupCodes
• CatalogueGroupTitle
• Price1
• PreviousPrice1
• CostPrice1
• PriceNote1
• ValidFrom1
• ValidTo1
• SecurityCode1
• CurrencyCode1
• Price2
• PreviousPrice2
• CostPrice2
• PriceNote2
• ValidFrom2
• ValidTo2
• SecurityCode2
• CurrencyCode2
• Price3
• PreviousPrice3
• CostPrice3
• PriceNote3
• ValidFrom3
• ValidTo3
• SecurityCode3
• CurrencyCode3
• Price4
• PreviousPrice4
• CostPrice4
• PriceNote4
• ValidFrom4
• ValidTo4
• SecurityCode4
• CurrencyCode4
• SellOnlyInCurrencyCode
• MaxQuantityLimit
• TaxRuleOverride
• PaymentMethod
• ShippingStatus
• GMCShippingPrice
• Weight
• StockLevel
• StockLocation
• NonAvailabilityStatus
• RelatedGoodSubscriptionPlanCodes
• DeferredIncome
• SubscriptionPaymentDuration
• DurationNumber
• FixedDate
• RenewalCatalogueItemCode
• CaptureContactDetails
• NumberOfContacts
• CaptureAdditionalDetails
• CustomField1
• CustomField2
• CustomField3
• CaptureContactListName
• CancellationCutoffDays
• AcknowledgementMessage
• ISBN
• ASIN
• EAN
• UPC
• GTIN
• StoreCreditMultiplier
• CatalogueAttributeProfileName
• RelatedGoodMediaItemCodes
• RelatedGoodCatalogueItemCodes
• MultiDisplaySectionName
• SO
• Teaser
• Introduction
• PopUpImage
• PopUpImageAltText
• Thumbnail
• ThumbnailAltText
• IntroImage
• MainImage
• MainImageAltText
• MainImageAlignment
• BaseImage
• BaseImageAltText
• MainDetails
• AdditionalInformation
• SpecialOffer
• Text4
• Image2
• Image2AltText
• Image3
• Image3AltText
• Image4
• Image4AltText
• StepByStepTitle
• Credits
• CodeBox
• Link
• Keywords
• PageTitle
• PageDescription
• ArticleAttributes
• ArticleIcons
• ArticleTypes
• ManufacturerID
• Brand
• Manufacturer
• DateOfManufacture
• PlayingTime
• Languages
• Format
• CountryOfOrigin
• Version
• EventStart
• EventEnd
• EventLocation
• EventRecurrenceType
• EventNumberOfRecurrences
• RelatedCatalogueItemCodes
• RelatedArticleCodes
• RelatedArticleScreenNames
• AccountCode
• SecurityClearance