CyberStore leverages internal data to optimize use of the site from a user experience standpoint. Part of the methodology is read certain data about Items that is maintained in SYSPRO and import it into the CyberStore database. This process keeps the data closer to the CyberStore application while reducing the amount of additional overhead put on your SYSPRO server for regular shopper visits to your website. Therefore, during the course of using the CyberStore system, there exist various means for importing and updating this data from SYSPRO which are described below.
Syncing While Maintaining Items
When maintaining Items in the CyberStore Management Console, the application will perform synchronization of Items when performing the following actions:
- Adding single Items to CyberStore - When adding an Item to CyberStore through Item Maintenance by clicking the Add button, after saving the base Item information, a background task will be performed that queries the Item in SYSPRO, ignoring the CyberStore SYSPRO Cache, and then update the newly created Item's data in the CyberStore database.
- Updating single Items - When updating single Items using the Item Maintenance screen, after saving your updates, a background task will be performed that queries the Item in SYSPRO, ignoring the CyberStore SYSPRO Cache, and then updates the just updated Item's data in the CyberStore database.
For more about adding and updating Items, see the Item Maintenance topic
-
Bulk Importing Items to CyberStore - When importing Items to CyberStore through the Category option to Import Items (found on the Category context menu), the default is to create create an Operation that will query each Item imported, ignoring the CyberStore SYSPRO Cache, and then update each newly imported Item's data in the CyberStore database. While enabled by default, if desired, the Console user can choose to not create this Operation by un-checking the Update from SYSPRO checkbox on the Import Items pop-up.
Note:
The Operation Agent must be running in order to perform the Operation. If it is not running when the Operation is created, it will sit in queue until the agent is turned on.
For more about bulk importing Items, see the Category Maintenance topic.
System Tools for Syncing Item Data
Other than synchronizing Item data between SYSPRO and CyberStore for individual Items, one can choose to perform wholesale updates of all Items in CyberStore on demand to the latest SYSPRO data using either of the following tools:
- The Update All StockCodes from SYSPRO Operation - Using the CyberStore Operation Agent, it is possible to run either on demand, or on a pre-determined schedule the Update All StockCodes form SYSPRO Operation. By default this process can update all items in CyberStore with current data by querying each Item in SYSPRO, ignoring the CyberStore SYSPRO Cache, and saving the information to the CyberStore database. Options also exist to limit the scope of items to specific Items by stock code, or by Item Categories. See The Update Items from SYSPRO Operation topic for more information.
- Updating using System Utilities - Found within the Tools > System Utilities screen, there is an action button that can be clicked which will update all items in CyberStore with current data by querying each Item in SYSPRO, ignoring the CyberStore SYSPRO Cache, and saving the information to the CyberStore database This action occurs immediately and cannot be limited to specific Items or Categories (to do so, use the Operation described above). See the System Utilities topic for more information.
Automatic Syncing in the Front End
Beyond the ways in which SYSPRO Data in Items can be synchronized by Console tasks or tools, there also exist a few times during the course of a shopper's visit that information will be updated.
- Calculating Lead Time - If your catalog is setup to use and display lead time for your items, then when lead time is calculated using CyberStore's catalog business logic, an item is queried in SYSPRO, using the CyberStore SYSPRO cache, that will update the Item data with the returned data from SYSPRO.
- Moving Forced Items from Backorder - When Items that are serialized in SYSPRO are configured to allocate all or portions of an order line after placing a sales order (as set in the Site Manager > Order Integration screen), the Item being released will perform a query to SYSPRO, using the CyberStore SYSPRO cache, that will update the Item data with the returned data from SYSPRO.
Item Data Maintained in SYSPRO
The table below lists which CyberStore Item Master fields are used to store SYPSRO Data from an Item query:
| CyberStore Item Field |
SYSPRO Item Query Node (//InvQuery/StockItem/...) |
| 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 |
UserField1 |
| UserField2 |
UserField2 |
| UserField3 |
UserField3 |
| UserField4 |
UserField4 |
| UserField5 |
UserField5 |
| WarehouseToUse |
WarehouseToUse |
| ProductClass |
ProductClass |
| KitType |
KitType |
| SerialMethod |
SerialMethod |
| TraceableType |
TraceableType |
| ListPrice |
SellingPrice |
| ListPriceUOM |
PriceBasis |
