CyberStore Sample Files

Use these Excel workbooks as starting points for bulk item maintenance and Characteristic-value preparation. Download a fresh copy, save it under a working filename, remove all sample records, and retain only the columns that are intentionally part of the task.

In an item-update import, a blank cell writes a blank value to the corresponding CyberStore field. Remove an unintended column from the workbook instead of leaving its cells blank.

The supplied files contain example data, not production-ready records. Test a small, easily verified set in a non-production environment before applying a large update.

Item Characteristic Data Worksheet

Download the Item Characteristic Data Worksheet

Use this workbook to organize stock codes and Characteristic values before pasting them into Setup > Characteristics > Import. It is a preparation worksheet, not the item-update workbook uploaded through System Utilities.

The workbook has one Item Characteristics sheet. It contains instructions, one example stock code, and one example Characteristic; it has no formulas.

Build the worksheet

1. Put one StockCode in each data row of the first data column.
2. Add one Characteristic per column to the right of StockCode.
3. Use the exact Characteristic name maintained in CyberStore.
4. Add an asterisk after a Characteristic name when recording that it is used for filtering, for example Weight*.
5. Put the display suffix in parentheses after the name, for example Weight* (lbs).
6. Enter the value for each stock code and Characteristic intersection. Leave the cell blank when no value applies.
7. Separate multiple values in one cell with semicolons, for example Blue;Green;.

The supplied example pairs stock code A100 with Weight* (lbs) value 35.

Import one Characteristic at a time

In the Characteristic Values import window, CyberStore accepts stock-code/value pairs. For the selected Characteristic, copy the StockCode cells and the adjacent value column from Excel, then paste them into the import area with the stock code on the left. Do not paste the worksheet instructions or heading row. Review the pairs before selecting Import Values.

See Characteristic Values for the import screen and accepted comma- or tab-delimited layout.

Item Maintenance Grid Export

Download the Item Maintenance Grid Export

This workbook is a populated example of item data exported from the maintenance grid. Its single Sheet contains 11 columns and 131 sample item rows with no formulas. Use it to understand the export layout or as a starting point only after deleting every sample row.

Column	Purpose
StockCode	Existing CyberStore item identifier and the unique key required in the first import column. The import uses it to find the item; it does not change the stock code.
FriendlyStockCode	URL-friendly form of the stock code used by applicable catalog links.
Name	Shopper-facing item name or description.
FriendlyName	URL-friendly form of the item name used by applicable catalog links.
Headline	Primary shopper-facing catalog headline.
ShortDescription	Concise catalog description used where a shorter presentation is required.
LongDescription	Detailed item content; values can contain HTML supported by the item editor and storefront.
SubHeadline	Secondary shopper-facing catalog heading.
Title	Item page <TITLE> value used by the browser and search results.
MetaKeywords	Item page keyword metadata. Keep the value to 512 characters or fewer.
MetaDescription	Item page search-result abstract. Keep the value to 160 characters or fewer.

The export illustrates that real data can contain HTML and that not every item has a value in every column. If the workbook will be uploaded, remove any column that should not be changed and review placeholder or sample values before import.

Item Update Import File

Download the Item Update Import File

Use this workbook as a compact example for Tools > System Utilities > General > Upload Item Information. Its single Sheet1 contains the following 21 headings and one sample A102 row; it has no formulas. Delete the sample row before entering current data.

Column	Purpose and format
StockCode	Required first column. Identifies an item that already exists in CyberStore and is not changed by the import.
Name	Shopper-facing item name or description.
Headline	Primary catalog headline.
SubHeadline	Secondary catalog heading.
ShortDescription	Concise shopper-facing description.
LongDescription	Detailed content. The sample demonstrates supported HTML in the cell; review markup and referenced image paths before import.
Limit	Boolean item-quantity setting that limits selling to available inventory. Use 0 for false or 1 for true.
isHotBuy	Boolean Hot Buy presentation flag. Use 0 or 1.
isFeaturedItem	Boolean Featured Item presentation flag. Use 0 or 1.
InsuranceRequired	Boolean shipping-default flag indicating that the item requires insurance. Use 0 or 1.
Oversized	Boolean shipping-default flag indicating that the item is oversized. Use 0 or 1.
Approved	Boolean that controls whether the item can appear in the catalog. Use 0 or 1.
ApplyOnHandQuantityBuffer	Boolean that enables the item-level on-hand inventory buffer. Use 0 or 1.
OnHandQuantityBuffer	Numeric quantity offset used when the item-level buffer is enabled.
ShipDays	Numeric item shipping lead-time value.
ForceWarehouse	Boolean that makes the item use its designated SYSPRO warehouse-to-use. Use 0 or 1.
Title	Item page <TITLE> value.
MetaKeywords	Item page keyword metadata.
MetaDescription	Item page search-result abstract.
FriendlyStockCode	URL-friendly form of the stock code used by applicable catalog links.
FriendlyName	URL-friendly form of the item name used by applicable catalog links.

The supplied headings are a practical starting set. Include only fields intentionally being updated, use exact CyberStore field names, and confirm that any additional field is supported by the installed version.

Prepare and validate an item update

1. Confirm every StockCode already exists in CyberStore. This process updates items; it does not create them.
2. Put StockCode in the first heading cell and keep one item per following row.
3. Delete all sample rows and remove every column outside the planned update.
4. Use 0 and 1 for Boolean fields and numeric values for numeric fields.
5. Check HTML, URLs, friendly values, metadata length, and inventory or shipping settings carefully.
6. Save the working file as .xls or .xlsx.
7. Import a small test set through Upload Item Information and review the reported records read and items changed.
8. Verify the affected item pages, search results, inventory behavior, and shipping behavior before importing the remaining rows.

See Updating Item Data with Excel for the complete update workflow.