Synchronizing Item Data with SYSPRO
CyberStore keeps selected SYSPRO item information in its own database so storefront pages can use that information without querying SYSPRO during every shopper visit. Synchronization refreshes that local copy when the authoritative SYSPRO data changes.
The appropriate method depends on whether one item, an imported set, or the entire catalog needs to be refreshed.
Synchronization during item maintenance
When an administrator adds a single SYSPRO item through Item Maintenance, CyberStore saves the base item and starts a background task that queries SYSPRO without using the CyberStore SYSPRO cache. The returned information updates the newly created item record.
The same kind of background refresh occurs after an existing item is edited and saved. This keeps the SYSPRO-owned portion of that individual item current as part of ordinary maintenance.
Synchronization after a category import
A Category item import creates an Operation by default to query and update each imported item from SYSPRO. Clear Update from SYSPRO on the import screen only when that follow-up refresh is not wanted.
The Operation Agent must be running for the work to execute. If the agent is stopped, the Operation remains queued until the agent starts.
Refreshing many items
Use an Operation when a broader refresh should run on demand or on a schedule. The item-update Operation can refresh the entire catalog or limit processing to specified stock codes or Categories.
Tools > System Utilities > General > Update Item Data From SYSPRO provides a different option: it starts an immediate refresh of every CyberStore item. It cannot be limited to selected items or Categories. Because of that scope, it is better suited to an intentional full refresh than to routine targeted maintenance.
Storefront-triggered updates
Some storefront processing can also refresh item data. Examples include lead-time calculation and the release of certain serialized forced-backorder items. These paths use the CyberStore SYSPRO cache while updating the local item record with returned data.
The important distinction is ownership: SYSPRO remains the source for synchronized item values, while CyberStore stores a local copy for storefront use. Shopper-facing descriptions, images, Characteristics, associations, and other CyberStore-managed presentation data follow their own maintenance processes.
Item values copied from SYSPRO
The synchronized values below show how CyberStore item fields correspond to values returned by the SYSPRO item query.
| CyberStore item field | SYSPRO item-query value |
|---|---|
StockCode | StockCode |
Mass | Mass |
Volume | Volume |
Name | Description |
LongDescription2 | LongDesc |
TechnicalInformation | Narrations/TechnicalInformation |
Unit | StockUom |
AltUnit | AlternateUom |
PriceMethod | PriceMethod |
OtherUnit | OtherUom |
AltUnitConversion | ConvFactAltUom |
OtherUnitConversion | ConvFactOthUom |
AltUnitConversionFactor | ConvMulDiv |
OtherUnitConversionFactor | MulDiv |
UserField1 through UserField5 | Corresponding UserField1 through UserField5 |
WarehouseToUse | WarehouseToUse |
ProductClass | ProductClass |
KitType | KitType |
SerialMethod | SerialMethod |
TraceableType | TraceableType |
ListPrice | SellingPrice |
ListPriceUOM | PriceBasis |