Summary of enhancements:

  1. Bulk category import
  2. Category language import
  3. Brand bulk import
  4. Brand language import
  5. Support for JPG file format in FTP image import
  6. Bundle product inventory upload enhancement
  7. Bulk image disassociation
  8. Developer API to update reserve quantity.


Bulk categories import

Context: Merchants with many categories and frequent updates had to make the updates for one category at a time. The updates can be new category creation or updating the existing categories.  The bulk upload option is given to simplify the process and create/update multiple category information in one go.

Solution:

  • New bulk upload is added under products>Bulk tools>Merchant data imports
  • Select the Upload type as “Category” and download the default template.
  • Status of import can be tracked under “Task history”

Specifications of the upload:

    Create Category:

  • To Create categories using this upload, Category Name and Category Reference Code are Mandatory.
  • To create a sub-category(Child), Parent Category reference code, Category Name, and Category Reference Code are mandatory
  • Category hierarchy can be created up to 5 levels.
  • Example hierarchy: Category 1 > Category 2 > Category 3 > Category 4 > Category 5.
  • Seo and content info can also be added using this upload. If they are not passed, system defaults will be set for these fields.

    Edit Category:

  • Category Name and Category Reference code are mandatory for editing a category.
  • Category name, Seo and content info can be edited using this Upload.
  • If we don’t pass Seo and Content info, existing data will be retained.
  • Category Name and Category Reference code should be valid for updates to be successful.

Category language import

Context: Multilingual category information had to be added for one category at a time by selecting the desired language. A bulk option is provided to simplify this process.

Solution:

  • New bulk upload is added under products>Bulk tools>Merchant data imports
  • Select the Upload type as “Multilingual Category” and download the default template.

Specifications:

  • Category reference code and Language Reference code are mandatory.
  • Category reference code and Language Reference code should be valid.
  • Existing data will be retained if no values are passed for CategoryName, SeoPageTitle, SeoMetaKeyword, SeoMetaDescription, ContentTitle, ContentBody.

Brand bulk import

The bulk option for importing brands is provided for importing multiple custom brands at the same time. Status of the import can be tracked under the “Task History” section.

Solution:

  • New bulk upload is added under products>Bulk tools>Merchant data imports
  • Select the Upload type as “Brand” and download the default template.
  • The brand name is mandatory for this upload
  • Use the iso-codes under language configuration in cp for importing data in multi-languages.

 

Brand language import

The bulk option for importing brands is provided for importing multi-language information of custom brands.

Solution:

  • New bulk upload is added under products > Bulk tools > Merchant data imports
  • Select the Upload type as “Multilingual Brand” and download the default template.
  • The brand name is mandatory in this upload

 

Support for jpg file format in FTP image import

Enhancement: Users of “Ftp image file import” can now import jpg files in addition to png and jpeg.

 

Bundle product inventory upload enhancement

     Context: Location Wise Inventory for bundle products was not supported in the bulk inventory upload and users had to update inventory using the locations tab of add/edit single product page.

     Solution: Location Wise stock and price upload are enhanced to support the inventory uploads of bundle products. Only inventory can be updated and any price information passed for bundle products will be ignored.


Bulk image disassociation

Context: In the current system, users did not have an option to remove the image association to SKU through bulk upload. This meant users had to remove the associations one image at a time.

 

Solution and specification

An optional column “Action” is added in Bulk imagery content upload and can be used to disassociate images of a product.

Column Name

Action

Keyword for deleting the association

Delete

 

For a source merchant

All the image associations corresponding to the mentioned sequence will be disassociated if the LargeImage in matches with the existing large image of the product.

For a non-source merchant

Images will be disassociated for the mentioned Sequence if the LargeImage, SmallImage, and ThumbnailImage matches with the existing LargeImage, SmallImage, and ThumbnailImage of the product

 

Developer API to update reserve quantity

Context: Certain marketplace integrations do not send real-time order data to Capillary ACP connect. Capillary connect would only have details of purchased products and Reserve quantity can be used for blocking inventory.  The blocked inventory can be released when the order is booked in capillary ACP.

API specification:

Post api route: {{host}}/product/UpdateReserveQuantity/{{MerchantId}}

Sample request: 

{

"ProductReserveView": [{

"ProductSku": "sampleSku",

"VariantProductSku": "SampleVariantSku",

"ReserveQtyCounter": 11

}]

Sample response:

{'messageCode': '1004', 'Message': 'Successful', 'ErrorCode': 0}

  • Api supports bulk updates with a request array of productReserveView.