Load Article archive (ARTUPLOAD) - INP/14542
Will be released 17 March 2025 - Use this resource to prepare for the coming update.
On import of articles from the .CSV file, new articles will be created or existing updated, if ProductId is given in file.
The other columns in this table provide additional information about each field.
Recommended partial load
It is recommended to use the Load article purchase prices - INP/15539 to load purchase prices.
If you still decide to use this load for it, verify which fields are required in Load article purchase prices - INP/15339.
Load specific resilience - File structure and formatting
This load includes unique and additional features:
Automatic handling of decimal separators (comma vs. period) and certain date formats to reduce errors.
This load is not upper- or lowercase sensitive.
The following fields can be blanked out by sending in the value
<BLANK>.CustomField1
CustomField2
CustomField3
InternalNote
CountryOfOriginCode
DomesticCustomsTariffCode
EUCustomsTariffCode
PurchaseGroupName
Field names are updated to new conventions:
Example: PUGNO is now updated to PurchaseGroupName
Initial load of the Article archive
To be able to identify and update an article at a later time, the initial load must contain values in the fields Name, Manufacturer and the field CreateIfnotExisting must be set to 1. It is also recommended to add a value to the field EXTID.
Important
The initial load should contain values in the fields Name and Manufacturer.
The field CreateIfnotExisting must be set to 1.
It is recommended to add a value to the field EXTID.
Update of the Article archive
To identify the article to be updated, the load file must contain a value in the field ProductId or a combination of the fields Name+Manufacturer. The field EXTID can also be used.
Important
Mandatory fields are ProductId, or Name and Manufacturer.
Relevant Company setting (CSV)
If the listed setting is turned 'OFF', the field Manufacturer is not required.
Company setting (CSV) | Description |
|---|---|
Require Manufacturer on Products | If this setting is 'ON' - Manufacturer (MFR) is required when creating new Products (ART) |
Table
Possible fields to be loaded into RamBase are listed in the Field-column in the following table.
Field | Required | Length | Example | Description |
|---|---|---|---|---|
AssignInMultipleOf | 4 | Sometimes the products are packed together in a way that makes it preferable to keep them together when selling. When RamBase starts the process of assigning sales to stock or purchase backlog, this field is taken into consideration. If the available quantity is not in this multiple, the rest quantity will be requested for procurement. | ||
AutoCreateProductUnitAtGoodsReception | 1 | When activated, product units are automatically generated when goods are registered to stock | ||
AutoGenerateSerialNumbersForPurchaseOrders | 1 | Serial numbers can be added to all newly created purchase order items. The serial number is specified in the company setting ProductionSerialNumberCounter, which will increase afterwards. If the company setting AutoProductionSerialNumberPrefix is specified, the serial number will be prefixed by this value. | ||
BlockedForProduction | 1 | If a product is blocked for production, no production work orders with that product can be registered. | ||
BlockedForPurchase | 1 | If a product is blocked for purchase, no purchase quotes or purchase orders with that product can be registered. | ||
BlockedForSale | 1 | If a product is blocked for sales, no sales quotes, sales order requests, sales order change requests or sales orders with that product can be registered in this location. | ||
BlockedForShipping | 1 | If a product is blocked for shipping, no shipments can be sent to customers from this location. | ||
ClassificationCode | 10100010011002 | Product classification identifier | ||
ClassificationGroup | 10 | Product classification group | ||
ClassificationLevel1 | 1001 | Product classification level 1 | ||
ClassificationLevel2 | 1002 | Product classification level 2 | ||
ClassificationLevel3 | 1000 | Product classification level 3 | ||
ClassificationLevel4 | 1000 | Product classification level 4 | ||
ClassificationLevel5 | 1001 | Product classification level 5 | ||
CountryOfOrigionCode | DE | Two-character code (ISO 3166) identifying the default country where the product is produced. This value is inherited from the assigned goods reception(s). If not country of origin is specified for the goods reception(s), country of origin is retrieved from the product. If assigned to multiple goods receptions with different origin, the field will be empty. | ||
CreateIfnotExisting | 1 | Use the value 1, if product should be created if it does not match existing products | ||
CustomerExtId | 77597376 | External id, used for migrations to refers to customer in a different system. | ||
CustomerId | 15112 | Products customer identifier | ||
CustomersProductName | X12-GREEN-LASER | Customers/buyers name of the product | ||
CustomField1 | York | Custom field for grouping, sorting, categorizing and other purposes. Obsolete field | ||
CustomField2 | Cosmetics | Custom field for grouping, sorting, categorizing and other purposes. Obsolete field | ||
CustomField3 | Consumer | Custom field for grouping, sorting, categorizing and other purposes. Obsolete field | ||
DaysToExpediteScheduledStartDate | 12 | Number of days the production will start ahead of the scheduled start date. Set this value if you want a buffer to be sure you are ready in time. | ||
DefaultManufacturersProductManufacturer | INTEL | Manufacturer of the MPN | ||
DefaultManufacturersProductName | BX8071513700KE | Manufacturer's name of the product. Also known as Manufacturer Part Number (MPN). | ||
Description | X12 laser | Description of the product | ||
DetailedDescription | X12 laser with 5000 m long beam green light | Detailed description of the product | ||
DomestisCustomsTariffCode | 11.22.33.55 | Domestic customs tariff classification identifier | ||
EUCustomsTariffCode | 2513.20.00.00 | EU customs tariff classification identifier | ||
ExcludeFromSOPProcesses | 1 | Exclude product from sales- and operation (SOP) processes for location. Typically used for products/materials being purchased, but can also be set for products with product structure. | ||
ExclusivelyForCustomer | 102243 | If customer is specified, only this customer can place orders for this product. Customer id | ||
ExpectedWastagePercent | 5.0 | Standard percentage of wastage for product when used in a production work order in this location | ||
ExpectedWastageQuantity | 0 | Standard quantity of wastage for product when used in a production work order in this location | ||
ExternalReference | 776655 | External reference of the product. Typically used for storing product identifier for same product in external system | ||
ExtId | 678943 | External reference. Used in migration. Id in external system | ||
FreightPercent | 10.0 | Freight percent. Will, if added, be a part of the cost calculation | ||
GlobalTradeItemNumber | 3 014260 11553 | Global Trade Item Number (GTIN) is a 14 digit identifier for trade items (comprising among others of the former EAN International and Uniform Code Council). Examples of types of GTIN are UPC, EAN, JAN, ISBN | ||
Height | 30 | Height of the product in centimeters | ||
InternalNote | Don't sell this product without talking to the sales manager | Internal note regarding the product. Should not be exposed to customers. | ||
IsExternallyManufactured | 1 | True if product structure is manufactured externally, and not internally | ||
IsManufacturedInBatches | 1 | Products is either manufactured in batch product units, or single product units. When manufactured as single, each production unit of a production work order should result in separate product units. When manufactured in batches, all production units from one production work order should result in one common product unit. | ||
IsNonStock | 1 | True if this is a non-physical product which are no using assignments from the assignment archive | ||
IsTraceableMaterialOfProductUnit | 1 | During production of a product structure, each produced unit generates a list of traceable materials included in the finished unit. When this value is true, this product is included in the list of traceable materials. | ||
Length | 60 | Length of the product in centimeters | ||
LocationShortName | OSL | Unique abbreviation/short name of the location | ||
MainImageId | FIL/201026.100 | Main image of the product | ||
Manufacturer | PHILIPS | Manufacturer of the product | ||
ManufacturingAreaName | Area2 | Name of manufacturing area | ||
MeasurementUnit | pcs | Measurement unit used for this product, both in sales and purchase. | ||
MeasuringToolGroup | Thread Micrometer | Measuring tools group | ||
MinimumGrossMargin | 7.0 | The minimum gross margin, in percent, for the product | ||
MinimumWorkOrderQuantity | 2 | Minimum ProductionOrder quantity to a production | ||
MoistureSensitivityLevel | 5A | Moisture sensitivity level is an electronic standard for the time period in which a moisture sensitive device can be exposed to ambient room conditions. | ||
Name | X12-5000 | Name of the product | ||
NeedsMaterialReplacementToRelease | 1 | You can add a dummy article in productions which you replace with the actual product before production starts. This function is used in situations where it is undecided which product will be used in the final production. | ||
PackageQuantity | 20 | Total quantity of the product within a package | ||
PackageType | Box | Type of wrapping used for the package | ||
PalletQuantity | 40 | Total quantity of the product that can be on a pallet | ||
PlanningCategory | P33 | Planning category | ||
PreferredStockLocation | B-12 | Preferred stock location in this location for this product | ||
ProduceInMultipleOf | 4 | Quantity to produce in multiple of. Ex. if set to 2, you can only produce 2, 4, 6 etc | ||
ProductId | #125778 | Product Id | ||
PublicProductUri | https://www.vg.no/ | Public/external product URI for more information about the product. Will typically be an URL to product details at the manufacturer web site. | ||
PurchaseExpectedLeadTime | 50 | The expected lead time, in number of days, from ordering from supplier to delivery. Used in different purchase processes, typically when supplier is unknown. Note that this might differ from the standard lead times defined on the different suppliers. | ||
PurchaseGroupName | Laser group | Name of purchase group | ||
PurchasePrice | 12.45 | The purchase price of the product for this product supplier | ||
PurchasePriceCurrency | EUR | Three character code following the ISO 4217 standard | ||
PurchasePriceEffectiveDate | 2025.12.01 | The date the purchase price takes effect. The price will be effective from from and including this date. | ||
PurchasePriceExpirationDate | 2026.04.30 | The date the purchase price expires. | ||
PurchasePriceMinimumQuantity | 1 | The minimum quantity for this purchase price to be applied | ||
RENTAL | YES | |||
RENTALCUR | SEK | Currency | ||
RENTALPRICE | 1300.00 | Price | ||
ReorderPoint | 200 | A minimum amount of quantity which a location holds in stock, such that, when stock falls to this amount, the product must be reordered | ||
ReorderQuantity | 10 | Preferred quantity to use when reordering to this location. Is also used as order quantity when stock gets below reorder point. | ||
RequireSerialNumberAtGoodsReception | 1 | If all units of this product should have a serial number in stock, you should require serial number to be required at goods reception. This will ensure that serial number is specified before goods receptions with this product is registered. | ||
RequireSerialNumberBeforeShipping | 1 | If all units of this product should have a serial number before shipping, you should require serial number to be specified before shipping this product. Shipping includes supplier returns, shipping advices and stock transfers. | ||
Revision | A | Revision number | ||
SalesStandardLeadTime | 30 | The standard lead time, in number of days, from customer places order to delivery. | ||
SalesType | Defines if an article is of one of the types: Sales, Sales and rental, Rental, Subscription. | |||
SERVICEDELETE | Y | |||
SERVICEID | ART/#224377 | Link from service table to KM article. | ||
SERVICEMAIN | Y | "Y" if main service. | ||
Status | 4 | Status of the product | ||
SupplierExtId | 7788497532 | External id, used for migrations to refers to suppler in a different system. | ||
SupplierId | 23112 | Supplier id. Needed if supplier data or purchase data should be updated | ||
SupplierIsPreferred | 1 | Whether this supplier is preferred or not | ||
SuppliersMinimumOrderQuantity | 100 | A minimum order quantity (MOQ) is the lowest set amount of stock that a supplier is willing to sell. If you can’t purchase the MOQ of a specific product, then the supplier won’t sell it to you. Also note that if purchase quantity exceeds the MOQ, the purchase quantity should always be in multiple of the MOQ. | ||
SuppliersProductName | 22445566 | Supplier/sellers internal product name | ||
SupplierStandardLeadTime | 30 | Standard lead time in days for this product from this supplier | ||
Type | P | Type of product | ||
UDF_CustomFieldName | What ever | User defined fields. You may have several columns, one for each custom field | ||
UseProductIdAsProductName | 1 | Use the value 1, if product name should be set equal to product id | ||
Volume | 72000 | Volume of the product in cubic centimeters. Volume is calculated automatically as L* W* H (when the volume field is empty and L,W ,H have values). Volume can also be changed manually | ||
WarrantyPeriod | 720 | The time period (in months) in which the product may be returned or exchanged. The warranty period starts at the date of shipment to customer. | ||
Weight | 10 | 1.25 | The weight of the product in kilograms | |
Width | 40 | Width of the product in centimeters |