> For the complete documentation index, see [llms.txt](https://docs.partner.aboutyou.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.partner.aboutyou.com/user-guide/create-products.md). # Create Products {% embed url="" %} **Edit:** The EAN has been made mandatory since for all products to allow for product aggregation.\ \ \&#xNAN;*Every product listed on the platform must have a **valid EAN code** for unique identification. Official codes can be acquired via GS1.* *** ## Create a Product via UI When you use the “Add Products” form, you only need to enter the most essential details, such as the product’s name, its category, the countries where it will be sold, and the color ways you want to offer. After you submit this short form, the system automatically generates the product with its corresponding color ways, variants, and countries. You can enrich the product with additional data later on.\ \ **Tip:** If you are creating multiple products via the UI, check out our *Bulk Edit* feature. It is a highly efficient way to quickly enrich or update data across all your products simultaneously.\
*** ## Import Products via Excel To bulk-create or update products, go to “Import Products” in the left navigation. From there, you can either click “Import Products” to add entirely new products or “Import Stock & Price” if you only want to update stock and prices. If you interrupt an import, you can continue it later via the “Continue last import” section, and you can always review completed imports in “Your Last Imports.” ### Updating Existing Products The Excel import tool can also be used to update products that are already in your Seller Center (including those imported via Shopify). * Any data provided in a cell will replace the existing information for that variant. * If a field (e.g., Material Information) already contains data in the Seller Center but is left blank in your Excel upload, that data will be deleted. * Images are the only attribute protected from this rule. Leaving image columns blank will not delete existing images in the system. * Uploading a file with only a few EANs will not affect other variants or product masters already in the system. Missing rows are simply ignored. *** ### Product Import Steps The Excel import process includes three steps: #### 1. Select Category Choose one or multiple categories for your products. #### 2. Generate Templates The system creates one Excel template per category, which may take a few seconds. You can leave the page and return later if needed. #### 3. Fill and Upload Download the templates, enter your product information, then upload them. If you have multiple files, compress them into a single ZIP before uploading. *** ### Product Import Excel File Each generated template has three worksheets: #### Help Offers FAQs and information about attributes for that category. #### Product Feature Information Lists each attribute that requires a specific selection (e.g., dropdown choices). #### List Your Products Here This is where you enter the actual product data. Every row represents a single variant (size + color way), and if you sell in multiple countries, you can duplicate rows and change the country-specific prices. The style key you provide groups rows under the same product master. You can also specify a unique product name or add direct URLs to your product images. #### Material Compositions The Material Compositions tab works as a lookup table where each row defines a single material breakdown, linked back to your product tab via a unique identifier.
* Key: An ID of your choice (e.g., BAG\_LEATHER\_01). Paste this exact value into the "Material Composition (Textile)" column on the "List Your Products Here" tab. This Key serves as the only link between the two tabs. * Cluster: Represents a specific part of the item (e.g., Upper, Outer, Lining). Enter its name under Cluster Name (1), (2), or (3) - using one column per part. * Material Name / Fraction: Defines the material used in that specific part and its percentage share. Only use the .2 or .3 columns if a single cluster part is made of a material blend. The total fractions within any single cluster must always equal 100%. * Single Material Parts: If a cluster part consists of only one material, simply fill out the .1 cells (Material Name + 100) and leave the .2 and .3 fields completely blank.\ \ See the example below:\
*** ### Product Import Upload After uploading your Excel file, the Seller Center checks each row, groups them under the corresponding product master and color way, and creates the products. Automatic Publishing: Products will be automatically published (skipping "Draft" status) as long as: 1. All mandatory attributes are completed. 2. Valid images are present, either via URLs in the Excel file or previously added in the UI. If images are still missing, products will remain in "Draft" until they are provided.
*** ### Faulty Upload and Reports If one or more rows contain errors, the valid rows will still be created. The system then provides a downloadable report highlighting the problematic rows and explaining the issues. You can fix these rows in the report and upload them again without affecting the rows that were correct. *** ## Import Products using the API For information about the available API endpoints, please have a look at the API section of this documentation. *** ## How to Delete Published Products You can delete products that have already been published using either the Seller Center User Interface (UI) or the partner-facing API via the endpoint. #### 1. General Deletion Conditions * No Recorded Sales: A product variant can only be deleted if it has absolutely no recorded sales. The backend strictly blocks deletion if any sales history exists. * SKU & EAN Reuse: Once a product is successfully deleted, its SKU and EAN values are completely freed up and can be reused for new products. #### 2. Deletable Statuses & Deactivation Rules Whether you can delete a product immediately depends on its current status: * Deletable directly: Products in Draft, Pending Approval, Rejected, Inactive, and Needs Input statuses can be deleted right away. * Not deletable as-is: Products in Active and Pending Active statuses cannot be deleted directly. For Active or Pending Active products, the UI will only display a Deactivate button. Partners must first deactivate the product to change its status to Inactive. #### 3. How to Delete via the User Interface 1. Go to Manage Products in the Seller Center UI. 2. If the product is Active or Pending Active, click Deactivate to move it to the Inactive tab. 3. Locate the product in the relevant tab (e.g., Inactive, Draft, or Rejected). 4. Open the Edit Product Details section, where the Delete Product option will now be available to complete the deletion.\
--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.partner.aboutyou.com/user-guide/create-products.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.