Basic Guide to Bulk Import

this guide equips you with the knowledge to efficiently upload your product data into the nochannel commerce product information management (pim) system step 1 accessing bulk import upon logging in, navigate to the side menu of the nochannel commerce portal, go to pim, and click on bulk import by leveraging the bulk upload functionality, you can streamline product data entry, saving significant time and resources compared to manual data entry step 2 download required templates in the bulk import section, download the necessary templates, such as product and variant templates, to facilitate uploading product data using a single template file ensure to download the correct templates tailored to your data requirements in the pim system, there are six different templates to upload and populate your product data attribute define and upload your product characteristics such as size, color, and material attribute group organize and upload your related attributes into groups for better manageability, e g (product specifications) product template specifies the structure for your product information, detailing which attributes are required for each product products & variants combines product and variant information in a single upload file, streamlining and managing multiple product variations use the products and variants template to update your products and variants either individually or simultaneously note start by downloading the attribute , attribute group , and product template templates these templates form the foundation for your product data once downloaded, fill them with your product information and upload them back into the pim system then, you can proceed with downloading and creating products and variants note use the pre filled sample data as a guide for structuring your file remember to remove the sample rows before you save and import your final version step 3 fill in template details once the templates are downloaded to your system, open the template files in excel fill in all the necessary details, including product template id, tags, docid\ k048xo 0yr aiahk1eqwt and other relevant fields while filling out your bulk upload templates, you must add the following information and fields in the templates note within the templates, fields marked with an asterisk ( ) are mandatory , while others are optional for attributes id this is a unique identifier for the attribute it distinguishes each attribute from others name this is the internal name of the attribute it is used within the system to reference the attribute admindisplayname en us this is the attribute's name as displayed in the admin interface for english (us) users displaygroup this specifies the group in which the attribute is displayed it helps organize attributes into logical groups, making it easier to manage them inputtype this defines the type of input for the attribute (e g , text, dropdown, checkbox) choose the input type based on how you want users to provide the attribute value helpertext en us this is the help text displayed in the admin interface for english (us) users it provides additional information or instructions about the attribute to help administrators description en us this describes the attribute in english (us) it explains what the attribute is used for and any important details about it multivalued this indicates if the attribute can have multiple values (true or false) set it to true if you want users to be able to select various options or provide multiple entries priority this determines the order in which the attribute appears on the pim system attributes with lower priority numbers appear before those with higher numbers scope this specifies the attribute's scope, product, variant, and overrideable for more information on scope, refer to the docid 2kufgitssfwywk 3cvvyk guide isrequired this indicates if the attribute is mandatory (true or false) set it to true if users must provide a value for this attribute type this defines the data type of the attribute (e g , string, number) choose the data type based on the kind of data you expect for this attribute for more information on types, refer to the docid 2kufgitssfwywk 3cvvyk guide units this specifies the units for the attribute, if applicable (e g , kg, cm) provide units if the attribute value represents a measurement allowedvalues this lists predefined values allowed for the attribute use this for dropdowns or selections to restrict the choices available to users defaultvalue this specifies the default value for the attribute set a value here if you want the attribute to have a predefined value when users first encounter it minimum this sets the minimum value allowed for the attribute use this for numerical attributes to enforce a lower limit maximum this sets the maximum value allowed for the attribute use this for numerical attributes to enforce an upper limit minlength this specifies the minimum length for the attribute value use this for text attributes to ensure the value is not too short maxlength this specifies the maximum length for the attribute value use this for text attributes to ensure the value is not too long sites indicates the ids of the websites or online marketplaces where the product is listed and available for purchase these ids correspond to specific platforms or sales channels where the product can be found attributes these are additional attributes related to this attribute use this to link other relevant attributes, if needed (mandatory incase of custom attributes) contentbucketref this is a reference to the content bucket associated with the attribute use it to link the attribute to specific content storage producttype this specifies the product types to which the attribute applies use this to restrict the attribute to certain types of products collectiontype this defines the type of collection the attribute belongs to it helps in categorizing and managing attributes within collections note while inputting your product data, certain fields support multiple values to accurately input these values, please use a comma "," to separate each entry this format ensures that all relevant information is correctly processed and displayed custom attributes in the pim system pim systems allow you to create and upload custom attributes in the attribute template, which are customized details specific to your products think of them as labels you create to describe unique aspects of your items these custom attributes can be organized in a hierarchical structure, like a family tree a broad category, called a parent attribute, can have more specific details nested beneath it as child attributes this helps keep your product information organized and easy to manage example creating a shipping package custom attribute parent attribute shipping package this is the broad category for all your shipping information child attributes weight this specifies the weight of the shipping package dimensions this specifies the dimensions of the shipping package for custom attributes, you will define child attributes to add specific details based on your business needs you can combine these child attributes in different ways to best represent your product information for attribute groups groupid this is a unique identifier for the product template it ensures that each product template can be distinctly identified within the system groupname this specifies the type or category of the product that the group is for examples might include electronics, clothing, or furniture use this to categorize the product templates to make them easier to manage and apply description this provides a detailed description of the product template displayname this is the name of the product template as it will be displayed to users it should be clear and descriptive so users can easily understand what the template represents attributes this is a list of individual product attribute ids to include in the attribute group these attributes can be related to size, color, or material, and they will be associated with this product template attributegroups these are groups of related attributes that help you organize your product information more effectively for example, you might have a "product specifications" group that includes attributes like size, weight, and color note attribute groups are optional if you choose to define individual attributes sites provide the list of sites where the product template is applicable specify the sites if the template should only be used in certain locations or for specific instances for product templates producttemplateid this is a unique identifier for the product template it ensures that each product template can be distinctly identified within the system producttype this specifies the type or category of the product that the template is for examples might include electronics, clothing, or furniture use this to categorize the product templates to make them easier to manage and apply description this provides a detailed description of the product template displayname this is the name of the product template as it will be displayed to users it should be clear and descriptive so users can easily understand what the template represents attributes this is a list of attribute ids associated with the product template these attributes define the various properties or characteristics that products using this template will have (attributes are optional if any attribute group below is provided) ids added to this column will always be shown as unassigned attributes i e without a section attributegroups these are groups of related attributes that help in better organization of the attributes (attribute groups are optional if any attribute above is provided) note if you aren't sure which section an attribute belongs to yet, add the id to the attributes or attributegroups columns these will automatically appear under 'unassigned attributes' so you can organize them later sites provide the list of sites where the product template is applicable specify the sites if the template should only be used in certain locations or for specific instances section name use this header to add/update sections within a template section name & tooltips you can update names and tooltips for sections section order to change the order, simply update the number (integer) in the cell add or remove attributes or groups update ids for attributes or groups in a section default sections please note that default sections cannot be edited, and you cannot add or remove attributes at this time but you can update the order, edit the name and the tooltip text need help? use our excel templates as a guide for correct data structures for products & variants when preparing your bulk upload files for products and variants, you will need to provide the following information itemscope defines the scope of the item, indicating whether it is a product or a variant use product for products and variant for variants this helps in categorizing the type of item being uploaded itemid unique identifier for the item based on the item scope for products, this is the product id, and for variants, this is the variant id product template id identifier for the product template being used for the product this links the item to a specific product template, which defines the attributes and structure of the product or variant tags provide a list of tags that help in organizing and searching for the product tags can include keywords related to the product's features, uses, or category state set the state of the created product options included view only the product is visible but cannot be purchased hidden the product is not visible to customers normal the product is fully visible and available for purchase for more information on states refer to the docid\ k048xo 0yr aiahk1eqwt guide displayname en us display the name of the product in english (us) this is the name that will be shown to customers make it descriptive and user friendly activationdate specify the date on which you want the product to become active date formatting all dates must be formatted as yyyy mm ddthh\ mm\ sstzd e g 2009 07 01t00 00 00z in the pim system this format ensures consistency and accurate interpretation of date and time data across the system associateditems input the ids of related items, such as accessories or complementary products this helps in cross selling and creating product bundles description provide a detailed description of the product's features and specifications example the truck sleeper by zeen of 3lb memory foam and 6" of heavy duty furniture grade foam, for a full 8" of sleeping comfort, even when you are on the road brandname specify the brand to which the product belongs this helps in building trust and brand recognition deactivationdate specifies the date when the product becomes inactive or is no longer available for sale after this date, the product may be removed from listings or marked as unavailable media refers to the media assets associated with the product, such as images, videos, or audio clips these assets are used to visually or audibly represent the product to customers relatedids provides ids of related products that are typically recommended alongside the main product this helps suggest complementary or similar items to customers seo contains search engine optimization (seo) information for the product, including meta description, page title, and meta keywords these elements help improve the product's visibility and ranking in search engine results shippingmethodids lists the ids of available shipping methods for the product these ids correspond to different delivery options offered to customers during checkout sites indicates the ids of the websites or online marketplaces where the product is listed and available for purchase these ids correspond to specific platforms or sales channels where the product can be found taxcode specifies the tax code associated with the product, which helps determine the applicable taxes during purchase or checkout step 4 upload filled templates after completing the templates with all the required details, return to the nochannel commerce portal click on the upload file button at the top right corner of your screen to initiate the upload process select the completed template file from your system and proceed with the upload adherence to formatting and data requirements outlined in the template instructions is essential to avoid rejection errors by the pim system step 5 monitor upload status and results once you upload your file, the system begins processing it through a series of bulk upload states each upload is tracked using a unique feed reference, allowing you to monitor progress across different stages of the flow during processing, the feed moves through states such as scanning , mapping required , ready , pre processing , importing , post processing , error and committed these states represent validation, transformation, processing, and final commit stages within the pim system status updates appear in real time within the bulk import interface, showing the current stage of the feed without requiring a page refresh this is especially helpful for large files that may take longer to process enhanced feed tracking each bulk import generates a unique feed id that allows tracking pre processing, post processing, and commit stages separately viewing partial success where valid rows are completed, even if others fail monitoring progress for long running imports feed statuses update in real time without page reloads for a detailed explanation of these upload states, refer to the docid\ mubh0n6r8gmges liezcr guide upon a successful "commit" status, your product data will be uploaded and live on the pim system however, if the system encounters any errors during processing, proceed to step 6 step 6 resolve errors in your product data upload if any rows fail during processing, the system generates a detailed error report to help identify and correct issues quickly these reports provide structured information, including the feed reference, sheet name, row number, related entity ids (where applicable), and a clear description of the error during the bulk import process, errors may occur at different stages, such as processing , importing , or committing when this happens, the system generates a detailed error report to help identify and correct issues quickly each error entry includes structured information such as feed reference sheet name row number related entity ids (where applicable) clear error description this allows you to precisely locate and resolve issues within your upload file below are some common errors you might encounter duplicated skus provided ensure that all skus are unique duplicate skus will prevent the file from being uploaded invalid item scope provided check that the item scope is correctly specified as either product or variant an incorrect item scope will result in an error product skus are not needed; only sellable products need skus skus should only be assigned to sellable products non sellable products should not have skus invalid brand or brand does not exist verify that the brand name is spelled correctly and that the brand exists in the system an invalid or nonexistent brand name will cause an error these errors appear within the pim interface and can also be accessed through the notification bar each error entry includes identifiers such as the feed reference, sheet name, and row number, allowing you to locate the exact issue within your excel file quickly follow these steps to identify and fix the bulk upload errors locate errors as the feed moves through different processing statuses, any detected issues appear in the notification bar along with detailed references find errors in excel use the provided references (such as sheet name, row number, and ids) to locate the exact rows containing issues in your excel file correct errors update the incorrect values directly in the spreadsheet ensure all mandatory fields are filled skus and ids are unique item scopes are valid invalid data is removed upload again after saving your corrections, re upload the file the system will process the updated feed through the same bulk upload states until it reaches committed important to prevent data conflicts, always complete your import once you’ve started avoid making manual updates to your items until the process is fully committed for a faster workflow, you can use your exported data as an input file just ensure you remove any archived items first, as this feature will be added in a future update this structured error workflow ensures faster troubleshooting while allowing valid data rows to continue processing where applicable if you still encounter errors, you can reach out to our support team at for further assistance