Here is a list of the file's tabs:
FeatureGroup
This tab will list the filters available in your e-shop.
Let's follow one particular FeatureGroup as an example: TVSize.
Here, in the Spreadsheet, you can see that we gave this particular FeatureGroup a number, called FeatureGroupEntryId: 150,012. This will be its unique ID number.
NOTE: Make sure that you put a different number for every FeatureGroup element.
!! WARNING !!
The FeatureGroupEntryId number you will give to your FeatureGroups, should always be above 50,000.
The IncludeInAcumenOnline is whether TRUE or FALSE. If it is TRUE, it will be included in our polling system, called the Schedulers, and be updated periodically, if it is FALSE, it won't.
For more info about the Schedulers, please visit this page.
The OrderByPreferenceId column is for you to determine if a FeatureGroup has to be placed before another one.
The more the number in the column is closer to 1, the more your filter is going to be on top of the others.
Here, the OrderByPreferenceId for TVSize is set at 1 while the others are set at 100. You can see that on the website, TV Size is the very first filter.
The Active is whether TRUE or FALSE. If it is TRUE, it will be displayed on the website, if it is FALSE, it won't.
This is how the table will look like once imported into Accredo:
Features
This tab will list the Sub-filters available in your e-shop.
Let's follow the same example as above: TVSize.
TVSize comes with several sub-filters or Features.
Here, in the Spreadsheet, you can see that we gave each of these particular Features a number, called FeatureId. This will be their unique ID number.
NOTE: Make sure that you put a different number for every Features element. Also, it is important that the Features have something in commun when they belong to the same FeatureGroup. Here, TVSize was shortened into TVS for the commun part then, we took the number corresponding to the sizes to differenciate them: TVS_20 for 20", TVS_30 for 30" and so on...
The Description column is the correspondant text that will appear on the website, as a Sub-filter. But also in the Product Description > Filters and Categories tab, on the Product's page
You may notice that some Features are not displayed. The reason is simple: there is no product matching these Features. But if, in the futur, you add products with these Features, then it will be automatically added. We advised you to put as many Features as you can, even if you do not need them at the moment. It can be handy in the future and save you some time.
In the Value field, you can add some extra documentation related to a specific feature. It won't be visible by the customers but it will be link to the PDF tab for example and appear for all the product with this feature.
The Display Order Preference column is for you to determine if a Feature has to be placed before another one, within its FeatureGroup/filter.
You may notice that the FeatureGroupName and FeatureGroupId appear in Accredo, making it easy for you to remember from which filter these Sub-filter belong.
ProductFeatures
This tab will list the products and link them to the Sub-Catogies they belong to. In other word, it will link a product to its Features.
Let's follow one particular Product as an example: SAMLED32IN.
A product can have one Feature but also it can have many. By linking a product to all its Features, it enable the Filters to be efficient on your e-shop.
NOTE: Make sure to write a line per Feature.
Of course, products can share one or several Features.
Product
This tab will list the products and their details, that are not Features, such as their name, unit, prices, if they are new or not etc.
Let's follow the same particular Product as an example: SAMLED32IN.
The ProductId is the identification number of the product, usually it is the part number.
The Product Name is name of the product.
The Unit is the unit used to handle the products quantities.
The DisplayOrderPreference column is for you to determine if a Product has to be placed before another one, among all the other Products. The more the number in the column is closer to 1, the more your Product is going to be pushed on top of the others.
The IncludeInAcumenOnline is whether TRUE or FALSE. If it is TRUE, it will be included in our polling system, called the Schedulers, and be updated periodically, if it is FALSE, it won't. For more info about the Schedulers, please visit this page.
Web Description can replace the product name on the website if you want to display something more customer friendly as a product name. It has to be decided at the begin of the project.
ProductImages
In this tab, you can add images to the products. You can add several images for the same product. They will be displayed in the product's page.
With the IsMain column, you can set which of the pictures will be used as the main image for the product i.e. once a filter is activated, which image will be shown to illustrate the product.
The IsMain is whether TRUE or FALSE. If it is TRUE, it will be taken as the main image for the related product, if it is FALSE, it won't.
The ImageFileName is the name of the image you want to use for the related product.
NOTE: Make sure to write a line per Image.
The AltTag column will let you set an alternative text that will appear instead of the image if the user can't display the image (for example following a browser issue) or is using a screen reader. Here is an example where the AltTag has been set to: [IMAGE] and the image can't appear.
The TitleTag will set a title for your image.
The DisplayOrderPreference column is for you to determine if an image has to be placed before another one, among all the other images for the same product. The more the number in the column is closer to 1, the more your image is going to be pushed on top of the others.
CategoryGroups
This tab will list the groups of categories available in your e-shop(s). You can set several groups of categories on your website if you wish but you can also make a category group per Portal (i.e. per website).
Just like in the FeatureGroup tab, the CategoryGroupEntryId will give each category group a unique ID number.
NOTE: Make sure that you put a different number for every CategoryGroups element.
In the Name column, you can name your category groups. Here the example is set to "Category Filters".
Categories
This tab will list the Sub-categories available in your e-shop.
Let's follow an exemple related to the one above: ES_TV, the "TV & Video" sub-category.
Here, in the Spreadsheet, you can see that we gave each of these particular sub-categories a number, called CategoryEntryId.
NOTE: Make sure that you put a different number for every Categories element.
In the CategoryDescription column is the correspondant text that will appear on the website, as a Sub-category.
You can also see that we gave each of the sub-categories a number, called CategoryId. This will be their unique ID number.
NOTE: Make sure that you put a different number for every Categories element. Also, it is important that the Categories have something in commun when they belong to the same CategoryGroup. Here, "TV & Video" was shortened into "ES_" for the commun part then, we took the letters corresponding to this particular Category "TV": ES_TV.
The CategoryGroupEntryId will set in which Category Group this sub-category belongs.
The ParentCategoryEntryId will set its place in the category tree. For example, here "ES_LCDTV", "ES_LEDTV" and "ES_PlasmaTV" have all the number 1 in this field. If you check in the CategoryEntryId, 1 is the number given to "TV & Video". So "TV & Video" is the Parent-Category to "ES_LCDTV", "ES_LEDTV" and "ES_PlasmaTV".
This means that "ES_LCDTV", "ES_LEDTV" and "ES_PlasmaTV" will appear as Sub-categories from "TV & Video", once this one is selected.
Logins
In this table, you can transfer the customers' data so their account will remain as on the former website.
LoginEmail should be filled with the customer's email address to enter the website.
LoginPassword should be filled with the customer's password to enter the website.
The ERPCustomerId is the current ID (or Customer Code in Accredo) for a specific customer, from your system.
NOTE: The email address should be unique. You cannot set several Customer's ID to the same email address. But, you can set several email address to the same customer's ID.
ERPShipToId is the delivery address linked to this customer ID. But it can go much further than this and limit the access to a special delivery address.
Let's say your Customer 1 is a company with 5 other employees: Employee A, B, C, D and E. All of them, including Customer 1, order products on your website. So they all belong to the same Customer's ID (ERPCustomerId)
Customer 1 wants to be able to check the invoices for his orders but also the employees. Then, you will leave the ERPShipToId empty. The system won't limit the access to the invoices to a specified address. Customer 1 will then be able to look at all the invoices made by all his employees.
On the other hand, he doesn't want the subsidiaries to see his orders. You can set it up by adding a specific delivery address for the employee so they will only access the invoices delivered to the specified address (here, AddressA).
In the end, Customer 1 doesn't need his employees to access the other's employees' invoices. Then a specific delivery address has to be made for everyone of them.
LoginRoles
This table will allow you to create groups of customers. This will give you the opportunity to decide which price ( or payment method, etc) a specific customer will see.
Every LoginRolesEntryId will be a group of customer. The numbers have to be different on every line.
In the RollDescription column, you can name the group of customers.
LoginRoleRelation
In the LoginRoleRelation tab, you will join the Logins and the LoginRoles. In other words, you will attribute the roles to the customers' email to define their group (or groups) of customers.
The LoginAssignedRolesEntryId is the ID number for this particular customer/group combination. It has to be unique.
In the LoginEmail column, you have to enter the customers' email address. You can put the same email address several times if the customer belongs to several groups of customers.
The LoginRole column, will be where you attribute the role to the specified email address.
In the example below, the customers from "test.com" have all the same role. they are B2B AND they get invoices from their orders. On the other hand, the two customers from "AnotherTest.com", are B2C too but they don't get invoices as they don't belong to the groupe 4. Instead, because nothing else is specified for them, they will pay their orders with the default payment option available on the website. The last customer, Customer4, is a B2C and only get to pay by Credit Card.
ProductDescription
In this tab, you will be able to give your product a description that will be displayed on the product page. You won't be limited in terms of lines but you will in terms of characters per line.
The ProductId should match the ProductId from the Product Tab.
In the Description column, you can write the description that will be displayed on the Description Tab on the Product's Page:
NOTE: The Description's lines are limited in number of characters depending on the solution you choose at the beginning of the project. Of course, once you chose how to "stock" your products' description, you cannot change it in the middle of the development. If you choose to insert the Description in Accredo, the limit will be at 60 characters per line. If you choose to insert the Description by our Tables, then the limit is set at 80 characters per line.
Here is an example of how it looks in Accredo:
ProductCategories
The ProductCategories tab will let you join the Products to their Category(ies).
The CategoryId is the same as the CategoryId in the Categories tab.
In the ProductId column, you have to match the productID from the Product Tab.
You do not have to put a line per link Category/Product. You have to link the ProductId with the "smallest" branch of the Category tree. Let's look at how the previous example, SAMLED32IN was link to its categories.
SAMLED32IN belongs to "TV & Video" but also to the sub-category "LED TV". So, as "LED TV" is already included in "TV & Video", and has no sub-categories, it is one of the smallest branch of the category tree. We will then link SAMLED32IN to "LED TV" In the Categories tab, its ID is: ES_LEDTV.
ProductAccessories
In this tab, you can link a product to accessories available for it. It can be helpful for the customer and guide them easily to the products they need.
The InitialProductNo is the product the accessories will be attached to. You have to use the ProductId from the Product Tab.
In the AssociatedProductNo column, you need to put the ProductId of the accessory you want to appear.
NOTE: You can set several accessories to the same product. But you need to make one line per accessory.
The DisplayOrderPreference column is for you to determine if an accessory has to be placed before another one, among all the other accessories. The more the number in the column is closer to 1, the more your accessory is going to be pushed on top of the others.
ProductReplacements
In this tab, you can link a product to replacement product(s) available in case the first one is out of stock or not available anymore etc.
The InitialProductNo is the product the replacement product(s) will be attached to. You have to use the ProductId from the Product Tab.
In the AssociatedProductNo column, you need to put the ProductId of the replacement product you want to appear.
NOTE: You can set several replacement products to the same product. But you need to make one line per replacement product.
The DisplayOrderPreference column is for you to determine if a replacement product has to be placed before another one, among all the other replacement products. The more the number in the column is closer to 1, the more your replacement product is going to be pushed on top of the others.