{"id":2309,"date":"2023-08-03T10:33:07","date_gmt":"2023-08-03T08:33:07","guid":{"rendered":"https:\/\/ecom-data.douglas.de\/?page_id=2309"},"modified":"2024-03-01T09:39:16","modified_gmt":"2024-03-01T08:39:16","slug":"how-to-product-information-excel-sheet_2","status":"publish","type":"page","link":"https:\/\/ecom-data.douglas.de\/index.php\/how-to-product-information-excel-sheet_2\/","title":{"rendered":"How to: Product Information Excel Sheet_2"},"content":{"rendered":"\n

<\/p>\n\n\n\n

<\/span>\"\"
\n

How to: Product Information Excel Sheet<\/p>\n<\/div><\/div>\n\n\n\n

for the article information-upload in b-Managed<\/em><\/p>\n\n\n\n

<\/h1>\n\n\n\n

<\/p>\n\n\n\n

First of all: <\/strong>Please download the current version of our product information sheet from the b-Managed dashboard
To activate the macros, you need to accept the yellow headline up to two times (\u201cenable editing\u201d & \u201cenable content\u201d)<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n

\"\"<\/figure>
\n

– If your excel macros are blocked, the ActiveX boxes and multiple choice
drop downs will not work and a red bar appears.<\/p>\n\n\n\n

– Then please head to developer tools\/ macro security\/ Trusted storage locations and add
the folder path you have safed the files in. Then save the file and restart Excel.<\/p>\n\n\n\n

– In case you are working with Apple devices or in case your organization has blocked Visual
Basic Applications in general, please just download our product information file without
ActiveX-Boxes. You will always find them on your dashboard in bManaged. <\/p>\n<\/div><\/div>\n\n\n\n

\n\n\n\n

Now you can start to enter your article information:<\/p>\n\n\n\n

Columns A \u2013 J are the mandatory fields in the tab MASTER DATA:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If you have texts in other languages additional to the German text, you can enter them here:<\/p>\n\n\n\n

To open the language, please press the +<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n





<\/p>\n\n\n\n

There are Drop-Down functions for the fields Product Type and Gender.
If you see a Drop-Down, it is mandatory to use it, otherwise b-Managed cannot convert the entered data.<\/p>\n\n\n\n