Announcement

Collapse
No announcement yet.

Import / Export Customers of Groups / Availability Group / Price Group

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

    Import / Export Customers of Groups / Availability Group / Price Group

    Is there any way to import/export customers to/from their group through the MM9 admin?

    I have a price group and an availability group. There are +2500 customers, with only about +/-800 not belonging to either/any group. So, it would be helpful to be able to import/export customers of groups.

    If yes...directions would be nice.

    Thanks so much!

    Jamie
    Jamie Donaldson
    JSDVS Web Design / Development
    Web Design | Web Development | E-commerce Design & Integration

    #2
    Re: Import / Export Customers of Groups / Availability Group / Price Group

    Tap, tap, tap...testing...is this thing on? Guess not, huh?

    Jamie
    Jamie Donaldson
    JSDVS Web Design / Development
    Web Design | Web Development | E-commerce Design & Integration

    Comment


      #3
      Re: Import / Export Customers of Groups / Availability Group / Price Group

      If there's no built-in way to import/export this data, I'll be glad to give you a quote for a custom solution.

      Thanks --
      Kent Multer
      Magic Metal Productions
      http://TheMagicM.com
      * Web developer/designer
      * E-commerce and Miva
      * Author, The Official Miva Web Scripting Book -- available on-line:
      http://www.amazon.com/exec/obidos/IS...icmetalproducA

      Comment


        #4
        Re: Import / Export Customers of Groups / Availability Group / Price Group

        Hi Kent!

        You did a custom job for me before on another site for a different function, and it was perfect! If I get no replies in the next day or two, I'll be emailing you.

        Thanks,

        Jamie
        Jamie Donaldson
        JSDVS Web Design / Development
        Web Design | Web Development | E-commerce Design & Integration

        Comment


          #5
          Re: Import / Export Customers of Groups / Availability Group / Price Group

          You can export customers assigned to existing price/availability groups. There is no CSV import yet but this data can be imported via XML. If you can get you customer data in this format you can import using the "Import Data via XML" import:

          Code:
          <AvailabilityGroupCustomer_Assign group_name="wholesale" customer_login="test123" />
          Code:
          <PriceGroupCustomer_Assign group_name="20off" customer_login="customer123" />
          Brennan Heyde
          VP Product
          Miva, Inc.
          [email protected]
          https://www.miva.com

          Comment


            #6
            Re: Import / Export Customers of Groups / Availability Group / Price Group

            Originally posted by Brennan View Post
            You can export customers assigned to existing price/availability groups. There is no CSV import yet but this data can be imported via XML. If you can get you customer data in this format you can import using the "Import Data via XML" import:

            Code:
            <AvailabilityGroupCustomer_Assign group_name="wholesale" customer_login="test123" />
            Code:
            <PriceGroupCustomer_Assign group_name="20off" customer_login="customer123" />

            Thanks Brennan. That is helpful. What about products? Is there a method to import/export products to those groups? Will Miva ever make the customers and products import via CSV for availability/price groups?

            Jamie
            Jamie Donaldson
            JSDVS Web Design / Development
            Web Design | Web Development | E-commerce Design & Integration

            Comment


              #7
              Re: Import / Export Customers of Groups / Availability Group / Price Group

              Not yet via csv. Here is the XML tags:

              Code:
              <AvailabilityGroupProduct_Assign group_name="Bard" product_code="instrument" />
              <PriceGroupProduct_Assign group_name="Warrior" product_code="mail-fullplate" />
              Brennan Heyde
              VP Product
              Miva, Inc.
              [email protected]
              https://www.miva.com

              Comment


                #8
                Re: Import / Export Customers of Groups / Availability Group / Price Group

                Originally posted by Brennan View Post
                Not yet via csv. Here is the XML tags:

                Code:
                <AvailabilityGroupProduct_Assign group_name="Bard" product_code="instrument" />
                <PriceGroupProduct_Assign group_name="Warrior" product_code="mail-fullplate" />
                CSV sure would be great. Hope it will come along sometime. Thanks for the code, Brennan.

                Jamie
                Jamie Donaldson
                JSDVS Web Design / Development
                Web Design | Web Development | E-commerce Design & Integration

                Comment


                  #9
                  Is there a way to use xml to assign a product as qualifying for a price group offering a basket discount? I tried the above for a basket discount group and it denied it throwing an error stating that the group didn't assign a discount to a product. It works fine for a product based discount, just not basket.
                  Ted Hust
                  AarcMediaGroup.com

                  Celebrating 13 Years of Outstanding Service & Support
                  Miva Merchant Design

                  Comment


                    #10
                    Yes here is the code:

                    Code:
                    <PriceGroupQualifyingProduct_Assign group_name="xxx" product_code="yyy" />
                    Brennan Heyde
                    VP Product
                    Miva, Inc.
                    [email protected]
                    https://www.miva.com

                    Comment


                      #11

                      I tried something similar to assign products to the "Discounted Products" price group:
                      <PriceGroupDiscountedProduct_Assign group_name="xxx" product_code="yyy" />
                      but that didn't work..... Any ideas?
                      David Limon
                      E-Commerce Signal

                      [email protected]
                      http://www.ecommercesignal.com
                      http://www.davidlimon.com

                      Comment


                        #12
                        It should just be:

                        Code:
                        <PriceGroupProduct_Assign group_name="Warrior" product_code="mail-fullplate" />
                        http://docs.miva.com/xml/pricegroupproduct_assign
                        Brennan Heyde
                        VP Product
                        Miva, Inc.
                        [email protected]
                        https://www.miva.com

                        Comment


                          #13
                          Oops, got it - Thanks Brennan!
                          David Limon
                          E-Commerce Signal

                          [email protected]
                          http://www.ecommercesignal.com
                          http://www.davidlimon.com

                          Comment

                          Working...
                          X