Basic Guide to Bulk Upload

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 upload upon logging in, navigate to the side menu of the nochannel commerce portal, go to pim, and click on bulk upload 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 upload 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 create and upload your product information, including names, descriptions, and categories variants facilitates the upload of product variants, detailing variations such as product sizes or colors products & variants combines product and variant information in a single upload file, streamlining and managing multiple product variations 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 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, states 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 attribute data types 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 attribute data types 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) 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) 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 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 states 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've uploaded your file, the system will begin processing it the import time may vary depending on the file size and complexity of your data during the upload process, you'll see various states displayed on screen, such as scanning, processing, importing, and batch commit these represent different stages of the import process for a detailed explanation of these upload states, refer to the bulk upload states docid\ mubh0n6r8gmges liezcr guide upon a successful "batch 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 the upload is unsuccessful, you will need to review the errors provided by the system 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 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 exists in the system an invalid or nonexistent brand name will cause an error these errors will be shown at the bottom left of the screen in the pim system you can also visit the notifications bar to view all error reports use the id to find the corresponding issue in your excel file and fix it follow these steps to identify and fix the bulk upload errors locate errors the pim system will display a notification bar listing errors with detailed descriptions and ids find errors in excel use the error ids from the pim system to search your excel sheet these ids will pinpoint the exact rows where the errors occurred correct errors once you've identified the errors in your excel sheet, correct them accordingly ensure all skus and ids are unique, the item scope is correct, and each field is filled with accurate information upload again after correcting all errors, save your excel sheet and upload the entire file again to the pim system if you still encounter errors, you can reach out to our support team at upstartcommerce\@support com for further assistance