Netsuite Binning Transition for small business

Netsuite Binning Transition for small business


Job Description


- Use NetSuite Advanced Binning System to assign unique locations to our SKUs inside of the warehouse inventory.
- Use bin numbers to signify location in the warehouse- These locations are numbers made up of data points. The ability to parse this series will allow us to see, for example, how much of the space on a given shelf we are utilizing.
- Build a technology plan that allows both for auto-updates and for manual overrides

Need help from NetSuite developer / expert:

1) Assign all items to a bin location before we move to the new warehouse:
a. Auto-update all items to “Use Bins”
b. Auto-update all store A, B, C locations to a single “store bin” per location
c. Mass upload (CSV or excel) new SKU-bin warehouse locations onto item records
d. Mass create 50 bin locations per shelf

2) Explore customization of our binning system by building 4 new field types
a. On bin: Width of Bin We would like to specify the size of the bin used currently and be able to change this over time. Eg: 2” or 12”. Empty, new bins will be 0”
b. On bin: Field for each location data point Field for row, facing, shelf and unique locator
c. On item: “Parent-Size” name. This is a combination of the parent and size. Also known as “color-blind-sku.”
d. On item: size profile. For example, “contour bra” or “panty”.

3) Build the searches/ auto-updates / functionality in NetSuite to maintain our inventory:

Receive new SKUs into a bin
a. If we have other items with same Parent Size, auto-assign new SKU to that location. Have a manual override.
b. If this is a new Parent Size, identify available locations (A shelf is 48” wide, and know the width of bins on a given shelf- thus we can thus identify where there is free room.)
c. If the new merchandise does not fit with rest of Parent Size, use similar search as b. to identify possible locations. Have a manual override.
d. Process to create new locations. For example, perhaps we add a row.

Search to see which bins should be downsized
a. Export for each SKU: inventory on-hand-balance, “size profile” and size of bin to see which items should be downsized.

Open Attachment