Announcement

Collapse
No announcement yet.

Inputing mass customer details

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Inputing mass customer details

    Hi.
    Is it possible to recreate a database in a new store containing upto 9000 customers details from a previous (non actinic store)?

    I have been asked to build a new store, but the client wants to keep all the existing customer account details - name, address, login details, email address, etc from the current store.

    I really wouldn't want to enter every piece of data in manually. Is there a quicker method?

    Thanks

    #2
    Actinic information is held within an Access database, after some manipulation you shoudl be able to recreate the existing structure. It will be a case of cross-referencing your current fields to the ones actinic needs.

    You could always download the free 30 day trial and see the format it takes.

    Comment


      #3
      You should build a hierarchical import file for import into Actinic from the information that you have, to check the format, enter one set of details manually and then export the details, then use the detail in the file produced as your template (the format is also in the help).

      I wouldn't recommend trying to enter this information straight into the database as the structure of the accounts information is a little tricky.

      Regards,
      Jan Strassen, Mole End Software - Plugins and Reports for Actinic V4 to V11, Sellerdeck V11 to V2018, Sellerdeck Cloud
      Visit our facebook page for the latest news and special offers from Mole End

      Top Quality Integrated label paper for Actinic and Sellerdeck
      A4 Paper with one or two peel off labels, free reports available for our customers
      Product Mash for Sellerdeck
      Link to Google Shopping and other channels, increase sales traffic, prices from £29.95
      Multichannel order processing
      Process Actinic, Sellerdeck, Amazon, Ebay, Playtrade orders with a single program, low cost lite version now available from £19.95

      Comment


        #4
        You can import customer data into Actinic via a structured text file. Actinic calls this a Hierarchical Import.

        Look in the Actinic help for Importing Content into Actinic.

        There's also a sample import file in C:\Program Files\Actinic v8\Sites\Site1\Common\SampleCustomerImportFile.txt. Example below.
        Code:
        Header:Customer,Name,External Reference,Price Schedule,Status,Payment Method,Email On Order,Email Address,Telephone,Fax,Contact Name,Salutation,Title,Comments,Invoice Address,Invoice Address Rule,Purge
        Header:CustomerAddress,Name,Line 1,Line 2,Line 3,Line 4,Post/Zip Code,Country ID,Valid Invoice Address,Valid Delivery Address,State ID,Exempt Tax 1,Exempt Tax 1 Data,Exempt Tax 2,Exempt Tax 2 Data,Purge,Residential/Commercial
        Header:CustomerBuyer,Username,Password,Status,Invoice Address Rule,Invoice Address,Delivery Address Rule,Delivery Address,Email On Order,Email Address,Maximum Order Value,Name,Salutation,Title,Phone,Fax,Limit Order Value,Hide Retail Prices,Purge
        Header:PriceSchedule,Schedule Name,Base schedule,Calculation Method,Calculation Factor
        
        Customer,"Example Customer 1","100001",Retail,0,10002,0,"name@mail.address","0123 456 7898","0123 456 789","Contact name","","","",Invoice Address,1,0
        CustomerAddress,"Buyer Address","Buyer street address","","Buyer Town/City","Buyer State/Province/County","Postcode",UK,1,1,,0,"",0,"",0,0
        CustomerAddress,"Invoice Address","Invoice street address","","Invoice Town/City","Invoice State/Province/County","Post code",UK,1,0,,0,"",0,"",0,0
        CustomerBuyer,"Buyer 1","password",0,2,Buyer Address,0,Buyer Address,0,"buyername@buyer.com",0.000000,"Buyer name","","","0123 465 789","",0,0,0
        Customer,"Example Customer 2","100002",Retail,0,10002,0,"name@mail.address","0123 456 7898","0123 456 789","Contact name","","","",Invoice Address,0,0
        CustomerAddress,"Buyer Address","Buyer street address","","Buyer Town/City","Buyer State/Province/County","Postcode",UK,1,1,,0,"",0,"",0,0
        CustomerAddress,"Invoice Address","Invoice street address","","Invoice Town/City","Invoice State/Province/County","Post code",UK,1,0,,0,"",0,"",0,0
        CustomerBuyer,"Buyer 3","password",0,0,Invoice Address,0,Buyer Address,0,"buyername@buyer.com",0.000000,"Buyer name","","","0123 465 789","",0,0,0
        CustomerBuyer,"Buyer 2","password",0,0,Invoice Address,0,Buyer Address,0,"buyername@buyer.com",0.000000,"Buyer name","","","0123 465 789","",0,0,0
        I've also attached a copy here.
        Attached Files
        Norman - www.drillpine.biz
        Edinburgh, U K / Bitez, Turkey

        Comment

        Working...
        X