How to import Custom Orientations
Products can be imported from Excel to setup Custom Orientations instead of the regular Allowed Orientations
Products imported from Excel have their Allowed orientation mapped by default to "All six".
All six can be changed to "As defined", or to ".. or turned" by changing these mapped Default Fields to False: FlatOk, Turnable, SideUpOk, and EndUpOk.
Changing the FlatOk, Turnable, SideUpOk, or EndUpOk Mapped Fields to True or False can setup Allowed orientation for a Product to : 1) As defined, 2) .. Or turned, or 3) All six.
However, the 4th choice circled red below cannot be imported using the Mapped Fields above.
For Example, if a Product is not allowed to be loaded As Defined or as Defined and Turned, but can only be loaded turned then the Custom for Allowed
orientations must be used.
Above is the Custom Allowed orientation setting that must always load this Green Product turned. This Green Product must be imported with the Orientations field mapped.
Have an Orientations Map field to import Products that require Custom Allowed orientations.
The Orientations Map field uses a combination of 1, 2, 3, 4, 5, or 6 to import the desired Product's orientation(s).
Add an Orientations column to your Excel or CSV file for Cube-IQ to map from. Enter 1,2,3,4,5 or 6 in any combination for the Orientations column for each Product.
Here is an example of an Excel file where Products are imported using Custom Orientations.
|
ProductId |
Length |
Width |
Height |
Weight |
Description |
Orientations |
|
Blue |
20 |
30 |
40 |
10 |
As defined only Product |
1 |
|
Green |
20 |
30 |
40 |
10 |
Turned only Product |
2 |
|
Orange |
20 |
30 |
40 |
10 |
As defined and Turned Product |
12 |
|
Purple |
20 |
30 |
40 |
10 |
On Sides only Product |
34 |
|
Red |
20 |
30 |
40 |
10 |
On Ends only Products |
56 |
|
Yellow |
20 |
30 |
40 |
10 |
Turned, or Turned On its Side or End |
246 |
This is how the colored Products can get loaded into containers after importing.
Blue Product can load as defined, Orange as defined or turned, Purple on their sides, red on their ends, and yellow can only be loaded turned, on their side turned or on their back turned.
Map ORIENTATIONS field to the Orientations column before importing in the Flexi Import window
The dropdown menu above the Orientations Column in Flexi Data should be mapped to ORIENTATIONS.
Here is the example of the Excel file above with ORIENTATIONS mapped.
Here is where the Custom choice is selected for Allowed orientations of each Product above after they are imported.
The following is how each of the imported Products have their Allowed boxes checked for Custom orientations along with an illustration of how they can be loaded.
Blue Product can only be loaded As defined (1):
Green Product can only be loaded Turned (2):
Orange Product can only be loaded As defined or Turned (12):
Purple Product can only be loaded On Sides (34):
Red Products can only be loaded On Ends (56):
Yellow Products can load Turned or Turned On Sides or Ends (246):
Related Articles
How to import products in Excel to Cube-IQ
Cube-IQ can import Products from an Excel sheet Below is an Excel spreadsheet of products . ProductId Length Width Height Weight Description Powder 19.13 13.13 11 36 Crate of powder Chips 15 10.75 8.25 25 Corrugated chips Metal 15.63 10.44 2.75 24 ...How to import Containers in Excel to Cube-IQ
Cube-IQ can import Containers from an Excel sheet Below is an Excel spreadsheet of Sample Containers. Container Id Depth Width Height Weight Capacity Type Height to be Added Bottom to Top Compacting in Height Sample Medium Box 23 15 7 30 Box 0 FALSE ...How to import Loads in Excel to Cube-IQ
Cube-IQ can import Loads from an Excel sheet Below is an Excel spreadsheet of a Sample Import Load of Products included in the sample data when Cube-IQ is installed. Load ID Product Id Quantity Sample Import Load prd 1 60 Sample Import Load prd 2 40 ...How to Export a Custom CSV Report using SQL
Cube-IQ can export a Custom SQL Report to a CSV file A CSV file can be exported from Cube-IQ using SQL. This is useful for when you need to create a report of a Load for Excel or to read it into another application. Custom Export commands can be ...How to ensure Products are stacked only on Products with the same Product ID
Products can be configured to only stack on top of Products with the same Product ID. Here is an example of milk crates loaded on to a pallet where Products have not been configured to only stack on Products with the same Product ID. Although the ...