The Settings section gives access to options to configure the functionality of the software, and the options available to your team. This includes data import tools as well as information that affects orders and inventory items.
Payment Methods
Payment methods can be associated with your orders to make it easier for your accounts teams to track income by source.
Adding a new payment method:
- Open the Settings section.
- Select Payment Methods.
- Click the Add New button.
- Enter a Name.
- Click Save.
- The payment method will be available to map in Channel Integrations, or to amend/update in the orders themselves.
Editing a payment method
- Open the Settings section.
- Select Payment Methods.
- Click the blue button.
- Edit the Name.
- Click Save.
Deleting a payment method
- Open the Settings section.
- Select Payment Methods.
- Click the Red button.
- The entry should be removed from the list
- If a payment method is deleted, it will no longer be available to allocate to orders, but will be remembered by processed orders.
Shipping Services
Your shipping services let you track what labels and costs are associated with your orders being sent out, and trigger any specialised workflows.
- Manual services can be used where an integration is not available. This indicates where manual shipping labels should be produced, or can be used for ‘collection’ orders.
Adding a shipping service
- Open the settings section.
- Select shipping services.
- Click the add new button.
- Enter a name for the service.
- Specify a courier for the service to use.
- Tick the box if the service requires a tracking number.
- Click save.
Editing a shipping service
- Open the settings section.
- Select shipping services.
- Click the blue button for the service.
- Edit the name if needed.
- Edit the courier if needed.
- Update the tracking number option if needed.
- Click save.
Deleting a shipping service
- Open the settings section.
- Select shipping services.
- Click the red button for the service.
- The service will be removed.
- If a shipping service is deleted, it will no longer be available to allocate to orders, but will be remembered by processed orders.
Countries
The Countries list allows the system to store information for use when you’re selling internationally.
Adding a new country
- Open the settings section.
- Select countries.
- Click the add new button.
- Enter the country name.
- Enter the correct currency code.
- Enter the ISO code that identifies the country.
- Specify the country’s VAT or sales tax rate.
- Click save.
Editing a country
- Open the settings section.
- Select countries.
- Click the blue button by the country.
- Update the country name if needed.
- Update the correct currency code if needed.
- Update the ISO code if needed.
- Update the country’s VAT rate if needed.
- Click save.
Deleting a country
- Open the settings section.
- Select countries.
- Click the red button by the country.
- The country will be removed from the list.
- If a shipping country is deleted, it will no longer be available to allocate to orders, but will be remembered by processed orders.
Import
The Import functionality allows you to import information into your database in bulk using CSV files. This saves time and reduces mistakes
CategoryImport
This Import allows you to create new categories in bulk quickly.
- To import a Category file:
- Open the settings section.
- Select import.
- Select the category import option from the import type dropdown list.
- If this is the first time you have done this import:
- Click on the download template link.
- Save the file and open it.
- Review the columns and example data.
- Delete the example data and replace it with your own data.
- Save the file for upload
- Click the upload button by the file upload field.
- Select your file and click open.
- The system will attempt to match the file’s columns to an internal field automatically in the field list.
- If a field is incorrectly mapped, click the red button to remove the mapping.
- If a field has not been mapped that you want to import, click on the CSV field dropdown and select it.
- Select the internal field you want the information saved in from the field dropdown list, and click the map field button.
- When all the fields have been mapped that you want to import, click the import button.
- When data import successful is shown in the top right corner, navigate to inventory, and the category section to check the data imported successfully.
Fields
The Category import file contains the following fields:
Category Name (Name of inventory category to create)
ProductAttribute
This import lets you import or update the attributes of your products in bulk.
To import a category file:
- Open the settings section.
- Select import.
- Select the product attribute import option from the import type dropdown list.
- If this is the first time you have done this import:
- Click on the download template link.
- Save the file and open it.
- Review the columns and example data.
- Delete the example data and replace it with your own data.
- Save the file for upload
- Click the upload button by the file upload field.
- Select the file and click open.
- The system will attempt to match the file’s columns to an internal field automatically in the field list.
- If a field is incorrectly mapped, click the red button to remove the mapping.
- If a field has not been mapped that you want to import, click on the CSV field dropdown and select it.
- Select the internal field you want the information saved in from the field dropdown list, and click the map field button.
- When all the fields have been mapped that you want to import, click the import button.
- When data import successful is shown in the top right corner, navigate to Inventory, and the Products section to check the data imported successfully.
- The SKU must exist for it to be updated with the attributes in the file.
- If the attribute does not exist for that SKU, it will be created.
- If the attribute already exists for the SKU, the value will be updated with the value in the file.
Fields
The Product Attribute import file contains the following fields:
SKU (The SKU of the Product the Attribute will be saved against.)
AttributeName (The name of the Attribute (Case sensitive))
AttributeValue (The value for that Attribute for the specified SKU)
AttributeType (The Type of Attribute being added or updated (Type Attribute))
ProductImport
This import allows you to create or update products in bulk..
To import a Product file:
- Open the settings section.
- Select import.
- Select the product attribute import option from the import type dropdown list.
- If this is the first time you have done this import:
- Click on the download template link.
- Save the file and open it.
- Review the columns and example data.
- Delete the example data and replace it with your own data.
- Save the file for upload
- Click the upload button by the file upload field.
- Select the file and click open.
- The system will attempt to match the file’s columns to an internal field automatically in the Field list.
- If a field is incorrectly mapped, click the red button to remove the mapping.
- If a field has not been mapped that you want to import, click on the CSV field dropdown and select it.
- Then select the internal field you want the information saved in from the field dropdown list, and click the map field button.
- When all the fields have been mapped that you want to import, click the import button.
- When data import successful is shown in the top right corner, navigate to inventory, and the products section to check the data imported successfully.
- If the SKU exists, it will be updated with the data in the file.
- If the SKU does not exist, it will be created.
Fields
The Product Import file contains the following fields:
SKU - The SKU of the product.
Title - The Name of the product.
Barcode - The Barcode that identifies the product (UPC, ISBN, EAN).
Description - A text Description of the product.
UnitPrice - The Price you charge per item, inc VAT.
CostPrice - The CostPrice you pay for the item, ex VAT.
VAT - The VAT rate applied to this item
Category - Categories allow you to segment and organise your inventory. Specify a category name this product belongs to, if it does.
Weight - Weight of the item in the specified units (See General Settings).
Height - Height of the item in the specified units (See General Settings).
Width - Width of the item in the specified units (See General Settings).
Depth - Depth of the item in the specified units (See General Settings).
ParentSKU - If ProductType is Variation, then enter the Parent SKU for this product.
ProductType - Enter Variation if this is a variation child product.
PrimaryImage - Enter the URL/address to access the Primary Image to be shown for this product and used in listings.
Image URL 1 - Enter the URL/address to access an additional image to be shown for this product and used in listings.
Image URL 2 - Enter the URL/address to access an additional image to be shown for this product and used in listings.
Image URL 3 - Enter the URL/address to access an additional image to be shown for this product and used in listings.
Image URL 4 - Enter the URL/address to access an additional image to be shown for this product and used in listings.
Image URL 5 - Enter the URL/address to access an additional image to be shown for this product and used in listings.
Image URL 6 - Enter the URL/address to access an additional image to be shown for this product and used in listings.
Image URL 7 - Enter the URL/address to access an additional image to be shown for this product and used in listings.
Image URL 8 - Enter the URL/address to access an additional image to be shown for this product and used in listings.
Image URL 9 - Enter the URL/address to access an additional image to be shown for this product and used in listings.
ProcessOrder
If you are managing some of your orders outside of eBGCommerce, this allows you to quickly update orders to mark them as processed with tracking information.
To import a ProcessOrder file:
- Open the settings section.
- Select import.
- Select the process order import option from the import type dropdown list.
- If this is the first time you have done this import:
- Click on the download template link.
- Save the file and open it.
- Review the columns and example data.
- Delete the example data and replace it with your own data.
- Save the file for upload
- Click the upload button by the file upload field.
- Select the file and click open.
- The system will attempt to match the file’s columns to an internal field automatically in the field list.
- If a field is incorrectly mapped, click the red button to remove the mapping.
- If a field has not been mapped that you want to import, click on the CSV field dropdown and select it.
- Then select the internal field you want the information saved in from the field dropdown list, and click the map field button.
- When all the fields have been mapped that you want to import, click the import button.
- When data import successful is shown in the top right corner:
- Go to orders
- Select open orders.
- Search for an order number from the file in open orders.
- If this cannot be located, click the processed orders button and search for the same order.
- This will confirm the orders have been processed.
- If an order in the file does not exist, it will be ignored.
Fields
The Process Order Import file contains the following fields:
- Order Number - The order to be marked as processed
- Shipping Service Name - The shipping service used to dispatch the order
- Tracking Number - The tracking number for the parcel (If available)
StockLevelImport
To rapidly update stock levels in bulk, especially where you have multiple locations, faster and with less mistakes.
- To import a stocklevelimport file:
- Open settings.
- Select import.
- Select the stock level import option from the import type dropdown list.
- If this is the first time you have done this import:
- Click on the download template link.
- Save the file and open it.
- Review the columns and example data.
- Delete the example data and replace it with your own data.
- Save the file for upload
- Click the Upload button by the file upload field.
- Select the file and click Open.
- The system will attempt to match the file’s columns to an internal field automatically in the field list.
- If a field is incorrectly mapped, click the red button to remove the mapping.
- If a field has not been mapped that you want to import, click on the CSV field dropdown and select it.
- Then select the internal field you want the information saved in from the field dropdown list, and click the map field button.
- When all the fields have been mapped that you want to import, click the import button.
- When data import successful is shown in the top right corner, navigate to Inventory, and the products section to check the data imported successfully.
- If an order in the file does not exist, it will be ignored.
Fields
The StockLevelImport file contains the following fields:
SKU - The SKU of the product
Stock Level - The stock level to set for the product
Location - The inventory location the stock is stored in.
Template Design
Invoice templates can be branded and adjusted to go in with your orders.
Creating a Template
You can have multiple invoice templates in eBG Commerce.
- Open the settings section.
- Select template design.
- Click on the add new button.
- In the template designer window, give the template a name.
- Select the paper size you want to print the invoice on.
- The layout is made up of elements. You click these items in the elements list at the bottom left corner to add them to the layout area.
- Once an element is on the layout, you can adjust its size by editing the element height and element width values.
- You can click on an element and drag it to change its position using the left mouse button.
- If the element contains customisable text, you can click edit to select a field from the order to show in this area using the item data dropdown list.
- Click save when finished.
- You can change the font and font size for the document using the default font and default font size fields.
- The logo field can contain an image.
- Select it and click on edit to open the options.
- Click on select file and locate the image you want to display.
- Click open to select the file.
- Click save to load the image into the layout.
The customer address, order item and order total elements will contain that information from the order you’re printing the invoice for.
- Click on the x when selected to delete an element.
- When you’ve finished editing your layout, click save in the bottom right corner to exit.
Setting a template as default
If there are multiple templates, you can set one to be printed by default. All others must be manually chosen to be used.
- Open the settings section.
- Select template design.
- Find the row for the template you want to use as default.
- Click to tick the default field for it.
- You will see a message “Default template updated” to confirm the change.
Editing a template
- Open the Settings section.
- Select Template design.
- Find the row for the template you want to edit.
- Click the blue button to load it.
- Make any changes required.
- When you’ve finished editing your layout, click save in the bottom right corner to exit.
Deleting a template
- Open the Settings section.
- Select template design.
- Find the row for the template you want to delete.
- Click the red button to delete it.
- You will see a message “Template successfully deleted” to confirm the removal.
General Settings
Change Weight Units
- Open the settings section.
- Select general settings.
- Open the weight dropdown list.
- Select the metric or imperial unit that you want to use for the weights stored in eBG Commerce.
- Click save.
Change Size/Dimension units
- Open the settings section.
- Select general settings.
- Open the dimension dropdown list.
- Select the metric or imperial unit that you want to use for the dimensions of your products in eBG Commerce.
- Click save.
Import History
This section lets you review the status of your previous imports.
Viewing a previous import
- Open the settings section.
- Select import history.
- Search for the import log you want to review. If the list is long, you can click on a heading to sort the list by:
- Import type,
- Date of import,
- Status,
- Total count (records in import), or
- Passed (successfully imported).
- You can also filter out the list for those that match values in those columns by selecting or entering information.
- When you identify the import you want to check, click on the blue action button.
- You can sort the list of records by clicking on one of the headings.
- You can also filter the records shown by entering or selecting search terms under the headings.
- Click close when you have finished.
User Management
eBGCommerce supports multiple user accounts, with different levels of access to suit their responsibilities.
Adding new users
- Open the settings section.
- Select user management.
- Click on the add new button.
- Enter the first name and last name of the user.
- Enter the email address and a contact phone number for the user.
- Enable the permissions the user will need by section. Most sections default to view (Except view PII)
- View allows the user to open the section and review records.
- Create allows the user to open the section, and add new data/records.
- Edit allows the user to update records.
- Delete allows the user to delete data/records.
- Save the user once you have finished setting it up.
- The user will be emailed to login for the first time and set their password.
- By default, all users have view PII set to disabled.
Editing user accounts
- Open the Settings section.
- Select User Management.
- Locate the user account you want to update.
- Click on the Action button for that record.
Disabling user accounts temporarily
- Open the settings section.
- Select user management.
- Locate the user account you want to update.
-
Deleting user accounts
- Open the settings section.
- Select user management.
- Locate the user account you want to update.
- Click on the action button for that record.