Updating RAM Category Data by Import

When updating RAM category data by import, each packaging component can have three columns:

1. The packaging weight in grams
2. The material type ID
3. The RAM category ID

For example, for Cap & Dropper, the import column name is:

cap_dropper_grams

To update the full packaging information for Cap & Dropper, your import file can include these columns:

In this example:

• 5 is the packaging weight in grams
• 2 means Material Category ID 2
• 1 means RAM Category ID 1, which is Green

Important: Material Type Columns

For material type, always add:

_mat_type

to the end of the packaging column name.

For example:

cap_dropper_grams_mat_type

Do not use:

cap_dropper_grams_ram_type

_ram_type will not update the material type.

Important: RAM Category Columns

For RAM category, always add:

_ram

to the end of the packaging column name.

For example:

cap_dropper_grams_ram

Do not use:

cap_dropper_grams_ram_category

or:

cap_dropper_grams_ram_id

Example Import Columns

A simple import file could look like this:

This would update the product so that:

• Cap & Dropper weight is 5 grams
• Material type is ID 2
• RAM category is ID 1

Import Rules

Before uploading your file, please check the following:

• Every row must have a valid sku.
• Column names must match exactly.
• Column names must be lowercase.
• Material type columns must end in _mat_type.
• RAM category columns must end in _ram.
• Material category IDs must already exist in Planufac.
• RAM category IDs must already exist in Planufac.
• Blank packaging fields can be left empty if you do not want to update them.
• Save the file as CSV or XLSX before importing.

Viewing RAM Category Data in Reports

Go to:

Reports > Compliance > RAM Category

Link:

https://my.planufac.com/reports/ramcategory/list

This report shows product packaging RAM category information, including:

• SKU
• Product name
• Brand
• Compliance name
• Weight in grams
• Material type
• RAM category