File format of the customer list for off-line customer management#

This page is part of the instructions for off-line customer management. Via this page an example for a customer list can be generated and downloaded. This example does not have a fixed format but is based on the settings of the shop - address data, available list of products etc. - After a change in the shop we advise to download a new example customer list, knowing what data has to be filled in.

For instructions to configure the customer management click here.

The structure of a customer list is given below. The customer list consists of a number of fixed fields - obliged or optional - and a unlimited number of free fields.

Fixed fields#

  • Number - obliged: 1st column -
    This represents the general customer reference - customer number, debtor number -. This value can be used to synchronize with when a changed customer list is uploaded.
  • If the number does not yet exist in the customer list then a new customer created and a password is generated.
  • If the number in the new list corresponds with an existing number than the customer data is updated - password is saved -.
  • If a number does not exist anymore in the changed customer list then the customer is deleted. This field can also be used to let the customer to login with - refer to next point -
  • E-mail - 2nd column -
    This is the e-mail address of the customer. With this address the customer logs-in. Also the order confirmations are sent to this address. If the field e-mail is not in the second column, the customer logs-in with his customer number - column 1 -. In case the field does not exist at all in the customer list then the customer has to input himself the e-mail address when ordering. This can be used to give new customers access to the shop by means of a general login.
  • authorization - option for customer management gold and platinum: 3rd column -
    This indicates the authorization level of the customer. Optional values:
  • all - default -: the customer has all teh option available as adjusted with the editor of myshop.com.
  • order: the customer is only allowed to order - if ordering is activated in the shop -
  • quotation: the customer can ask for a proposal - if proposal is activated in the shop -
  • retrieve: the customer can only view at the products.
  • public - option for customer management gold and platinum: 4th column - With the column public an login account can be mad public assessable. This can be useful if a large group of users have to use the same login data. This way a a screened account can be opened for users who are not yet registered. Optional values:
  • Yes: this account can only be used by more than one user at a time. A public account has the restriction that the contents is not saved when the customer logs-out.
  • No: default: this account can only be used by one user at a time. After logout the contents of the shopping cart is stored on our server - default one week -. When a second user logs-in while an other user with the same data was logged in, the first user is logged out.
  • discount - option for customer management gold and platinum: 5th column - -
    If a customer get a fixed discount on the entire assortment you can adjust that in the column 'discount'. The discount can be given as a percentage but can also be negative - raise -.The discount is given over the price checked in the shopping cart.Pay attention that this column is not formatted and only contains numbers - no % signs -.
  • vat - optional for customer management gold and platinum: 6th column -For orders of customers outside the EU or customers who donate their VAT themselves no VAT has to be paid. - refer to VAT rules -
  • yes - default -: VAT is calculated - if selected in the editor of myshop.com -
  • no: VAT is not calculated
  • password - optional for customer management gold and platinum: column 7)- The functionality is as follows: If this field is empty when uploading a new customer list, a password is generated by the system. Is there a value filled in than this value is applied as password.If the customer list is refreshed and the field is empty the password is not updated, has this field a value than this new value is transferred and used as new password.
  • product list - option for customer management platinum -This column gives the product list which can be consulted by the customer. The product list is mentioned without extension. If more than one product lists can be consulted by the customer they are included in this column separated by a semicolon.
    Pay attention, if you change the name of the productlist you have to change it in the import file or the online custom management too. The name of a productlist which has been linked is capital sensitive. If you change a linked productlist to a file which includes only capitals in the title you have to take it up in the same way into the customer list too.
  • group1 - option for customer management platinum -This column gives the product lists out of the group which can be consulted by the customer. The column contains the name - without extension - of the product list.
  • group2, 3, 4 etc. - same as groep1 -

Free fields#

Beside the fixed fields a unlimited number of free fields can be defined. The free fields correspondent with the fields defined with the editor using the menu 'settings address data customer'

Previously these fields can be defined using the customer list. Therefore a distinction is made for general fields and fields as part of the delivery data.The last are preceded by a 'd' - delivery -. For example general fields: 'name', 'street', 'zip', 'city' For example delivery address fields: 'dname', 'dstreet', 'dzip' en 'dcity'.

The following two situations can be distinguished:

  • Field defined in excel customer file and in the address data screen - editor -.
    The value from the customer file is copied in the order process. The customer does not have to fill in these. If the field in the editor is defined as 'not editable' the customer cannot change this data.
    Example: name and address of customer
  • Field only defined in the address data screen - editor -
    The customer can give the data in the order process.
    Example: desired date of delivery

Advanced use of choice lists, check boxes and input fields in combination with the customer list.

If in the customer data screen a list of choices, check box or input field is defined, this value can be passed by means of the customer list. However it is also possible to send the offered options via the customer list. Therefore the options must be included and separated by a semicolon. Does it give only one value, this one will be used as selected in the standard list. Are there more options, the list is created based on data form the customer list.

Ask a question
General Help

  1. Welcome to myShop
  2. Search
  3. Keywords
  4. Print Manuals

  1. Subscriptions
      1. Affiliateshop
      2. VAT
      3. Terms and conditions
      4. Basic web shop
      5. Checkout only Basic
      6. Checkout only Professional
      7. Enterprise order system
      8. Extend subscription
      9. Order System regular customers
      10. Payment periods & discounts
      11. Professional Startup description
      12. Professional web shop
      13. Second webshop
      14. Terminate subscription
      15. Types of subscriptions
      16. To log in or not to log in?
      17. Customer management
      18. Affiliate
      19. Affiliate module
      20. Affiliate marketing
      21. Professional order system
  1. Payment
    1. Afterpay
    2. Beschikbare betaalsystemen
    3. Buckaroo
    4. Directe betaalmethoden
    5. docdata payments
    6. Electronische facturen rechtsgeldig?
    7. Internetkassa (ABN AMRO)
    8. Icepay
    9. iDEAL algemeen
    10. iDEAL ABN AMRO
    11. iDEAL ING bank
    12. iDEAL Rabo bank Professional
    13. iDEAL Mollie
    14. Klarna
    15. Multisafepay
    16. Ogone
    17. Omnikassa Rabobank
    18. PayPal
    19. Sisow
    20. Vemt
    21. Online betaalmethoden
  1. IPad Shop
    1. Ipad nieuw
    2. Ipad doorschakelen
    3. Ipad tekst
    4. Ipad links
    5. Ipad producten
  1. IPhone Shop
    1. Iphone shop

Recent News

  1. Cookies Law

My Shop

  1. Welcome
    1. Email Managment
      1. Management email addresses
      2. E-mail to more than one person
    2. Authorization
    3. Language
      1. Other languages
    4. DNS
      1. Use own subdomain
      2. Can I join my domain and email with myShop.com ?
      3. I see a white screen after set the DNS
  1. Pages
    1. Pages
    2. Header
      1. Add and modify the Logo
      2. Personal logo with address data
      3. How can I create the main menu?
    3. Blocks
      1. Blocks
      2. Speed up the shop
      3. How do I get text information in a page ?
      4. How I can edit a menu of the products ?
      5. Different menus of products
      6. How I can add YouTube videos on my Shop ?
      7. How I can add Social Media buttons ?
      8. Facebook Like Button
      9. Facebook Like Box
      10. Facepile
      11. Twitter Feeds
      12. Sitemaps
      13. Sitemaps No Pages
    4. Skins
      1. CSS Editor
        1. CSS Editor
      2. Layout and skins
      3. Edit skin
      4. Customize skin
      5. How do I set the layout of my shop?
    5. Tips
      1. Taylor search window
  1. Products
    1. Product List
      1. How do I put my products in the store?
      2. Change some fields
      3. Wizard
      4. Field names in product list
      5. Leave out fields in the product list
      6. Show product groups
      7. To layout fails
      8. Product lists and groups
      9. ProductList Copy and Menu Child
      10. Check url from Productlist
      11. Management product list
      12. Product List Data
        1. Product list upload failure
        2. Product list fails to appear
        3. Collect productlist externly
        4. Automatic uploading of product lists
        5. Collect dynamically customer data
      13. Productlist without layout
      14. Maximum number of products
    2. More Info
      1. Extra images
      2. Text in the \'more info\' screen
      3. Hyperlinks in more info screen
    3. Order settings
      1. Proposal system
      2. Remove the Popup
    4. Search
      1. Extended searching
      2. Speed up the shop
      3. URL-selection
    5. Price
      1. Show \'strike through\' prices
      2. Currency sign in the shop
    6. Variations
      1. Product Variations
    7. Related Products
      1. Related products and accessoires
    8. Tips
      1. Hyper links in product list
      2. Dummy article
      3. Custom Layout
        1. Create Own Layout
        2. Adjust layout product list
        3. Own layout screens
      4. Sort data
  1. Google
    1. Google Check
    2. Search engine
    3. My webshop and Google
    4. I can not verify my site with Google
    5. Google Overview
    6. Google Add Sitemap
    7. Google extra settings
      1. Attract visitors
  1. Order Process
      1. Sequence order process
    1. Shopping Cart
      1. Internet checkout only
      2. No products in shopping cart
      3. What is NaNNaNNaN in my shopping cart?
      4. Promotions
      5. Promotions
        1. Level discount
        2. Level discounts
    2. Address Data
      1. Have the terms of delivery accepted
    3. Shippings
      1. Order collection by customers
      2. Product delivery
    4. Payments
      1. Payment Methods
        1. Available payment systems
        2. Assurepay
        3. Bridgetools
        4. Buckaroo
        5. Checkout only ABN AMRO
        6. docdata payments
        7. Direct Payment methods
        8. Icepay
        9. iDEAL
        10. iDEAL Algemeen
        11. iDEAL ABN AMRO
        12. iDEAL ING bank
        13. iDEAL Postbank
        14. iDEAL Rabobank Lite
        15. iDEAL Rabobank Professional
        16. iDEAL Virtuele Kassa
        17. iDEAL Mollie
        18. My iDEAL link does not work
        19. Multisafepay
        20. Ogone
        21. Standard links for online payment
        22. Payment online
      2. Tips
        1. Payment methods to be integrated?
        2. PayPal
        3. Electronic invoice legal?
    5. Confirmation
      1. No order confirmations
      2. Disable warning
    6. Tips
      1. Adjusted order process
      2. Website integration with frames
      3. Website integration with i-frames
      4. Produce an order
      5. Definition of the \'back\' key
  1. Customers
    1. Customer management
  1. Connections
    1. General
      1. Google Analytics
      2. Google AdWords
      3. Supplier
      4. Link with King
      5. Statistics web shop
      6. Twenga
      7. Link with Exact
    2. Own Connections
  1. Order and Reviews
    1. Order Managment
      1. Fax orders
      2. Invoices and vouchers
      3. Back office link
      4. Link with backoffice (technical)
      5. Order management
      6. XML order document
      7. Printing order confirmation
    2. Reviews
    3. Export Orders
    4. Manage Authorizations
    5. Collect Data Externally
    6. Renumber Orders
    7. Own Layout

FAQ

  1. Frequently asked questions (FAQ)
  2. Questions to start with
    1. Chamber of Commerce subscription?
    2. Competitors of myShop
    3. Do I have to pay VAT?
    4. Law selling by the internet
    5. myShop banner
    6. Own domain
    7. Powered by myShop
    8. What is myShop?
    9. What is a product list?
    10. Who are we
    11. Preview myShop
    12. I do not have Excel
    13. How to create a product list with Excel?
    14. How to prevent copying
    15. Questions about subscriptions
      1. Which subscription is right for me ?
      2. I want to register, Do I need to rebuild the shop ?
  3. Questions about pictures
    1. How do I put images in my shop ?
    2. Image Maintenance
    3. Where are my pictures?
    4. Missing pictures
    5. More pictures on one line
    6. Multiple points of view
    7. Pictures in overview
    8. I get no pictures
    9. Different sizes
    10. How do I get images in my productlist ?
    11. How I can add a product picture in the order process?
  4. Questions about search
    1. Search options
    2. Background information about search technology
    3. Create deep links
    4. Direct link
    5. Select
  5. Questions about setup my shop
    1. Checklist to set up web shop
    2. Get my shop on-line
    3. Integration of own site
    4. Integration of own site (basic knowledge)
    5. Instructions for site integration
    6. Web shop setup
  6. Technical questions
    1. myShop technology
    2. System messages
    3. Browser related problems
    4. myShop on CD-ROM?
    5. myShop and cookies
    6. Javascript
    7. Personal parameters
    8. statistics404

Custom layout (technical)
Manuals
Newsletters