EQC: EQLink-Item Settings
This document identifies the fields transmitted between DB Distributor (DB/d) Custom Items to EQ Link(EQ/l) Item Maintenance. These screenshot display DB/d on the left and EQ/l on the right.
Item Settings
All items in DB/d are sent to EQ Link where they are configured for eCommerce. Non-editable fields are only changeable in DB/d. Editable fields are for eCommerce settings only.
Mapped Fields
Inventoried Items
Inventoried items (Item Class = Stock) have four fields from the Reorder tab in DB/d that export to the RO tab in EQ/l. This information is displayed on eCommerce reports.
DB/d eCommerce Item Settings
When an item is saved, the eCommerce window prompts a record to be added. Click Yes! If this window does not appear, go back, and add the Customer Parameter into DB/d Toolkit> eCommerce > Setup > Customer Parameters.
On the 3. Ordering tab, the option of “Create PO on order?” must be checked for custom items. This option forces eCommerce orders to generate a Purchase Order to the vendor assigned in the Custom Item master. Leave it unchecked for inventoried items.
*When un-checked the program searches inventory to generate the order. Backorders possible.
The Transfer of Information
A change file is generated automatically in Db/d and periodically transmitted to EQ Link through Flowpoint and the designated FTP site.
The auto-scheduler in EQ Link can import the file on a scheduled basis. The file can be imported manually by clicking on the Import from DBD button.
A progress window displays the import, and a log is available when complete.
EQ/c Item Settings
All items are imported into EQ Link. A default “Upload to Internet” setting controls the item’s status after import. Edit items to update eCommerce specific fields like categories, weight, and descriptions. Data in shaded fields can only be changed in DB/d.
Default Import Setting
eCommerce > eCommerce Maintenance > eCommerce Configuration.
DB/d Item Settings
These are the fields sent from DB/d > Custom Items:
- Item ID – header.
- Description – header.
- Item Class – EC Item Parameter (Create a PO checkbox). • Units of Measure – Pg 1.
- Reorder Qty: - Quantity point of reorder.
- Weeks: Calculated based on Reorder Point in Days
- Date: Estimated Reorder Date:
- Suggested Reorder Quantity – Pg RO (reorder).
- Latest Client Price – Pg Price.
- Price Plan tables – Pg Price.
EQ/l Item Settings
These are the minimum fields to configured to ensure proper item viewing and order generation.
- Default Unit Weight – Pg 3 (* = per UOM).
- Category – Pg 3.
- EQ/c Settings
o Set upload flag – General tab. (Mass Update feature)
o Long Description – Descriptions > Long Description
o Add Images – Images tab (35 max) (See Image Guidelines)
EQ/l Optional eCommerce Item Settings
These additional fields are optional, and setup is based on the client’s site configuration.
- *Extra Freight – Pg 3 (* = per UOM).
- Item Restrictions – restrictions by Client, State, Ship-To group, Country or specific Ship-To’s.
- Item Properties – restrictions by eCommerce Users.
- Attributes – selectable options (i.e.: shirt sizes & colors)
- EQ/c Settings
o Allowing Attachments
o Attribute Grid (if attributes)
o Show Inventory override
o Freight Exempt
o Retail Item
o Additional Descriptions
o Additional Images
o Additional Categories
o Suggested Items
Export to EQ/c to create the site.
Expediting Features
The Mass Change Item Field feature allows for multiple items to have their eCommerce settings changed. Click into Item Maintenance and enter the Client ID.
Click Tools and select Mass Change Item Fields
Select the field to change from the Field: drop-down. Example: Upload to EQ/c.
Select the Value to change.
Select the items to change by checking the box to the left of the item then click SAVE. A warning appears to before the change is made in case cancelling is needed.
