Announcement

Collapse

Posting Rules

Posting Rules
This forum was created to help 3dcart users share tips on getting the best out of the service, offer knowledge and experiences about e-commerce in general, and to promote a positive environment in which our merchants can request/dispense advice regarding best practices.

The forum was not created for 3dcart users to submit requests for customer support. Any support related thread will be removed and a support ticket will be placed on your behalf. If you have technical difficulties please visit http://support.3dcart.com.

The 3dcart forum is also not intended to be a medium in which to express dissatisfaction about 3dcart's service, policies or its management and staff. Threads of this nature will also be removed from the forum. If a support issue with your 3dcart store was not resolved in a satisfactory manner; or if you feel that a particular 3dcart offering/policy is not to your liking, please let us know by emailing [email protected] so we can address your concerns directly.

Again, our purpose is to cultivate a positive learning environment for our merchants rather than platform in which to express grievances.

Very Important Rules:
* Never give away your store administration login/password in this forum.

Should you need technical help, please let 3dcart staff help.
Also, please be aware that 3dcart staff will NEVER need to ask for your 3dcart related passwords.

General Rules:
* While debate and discussion are acceptable, we will never tolerate rudeness, insulting posts, personal attacks or inflammatory posts. Our decision is final in these matters.
* Please refrain from posting meaningless threads, one word (or short) nonsensical posts, or similar postings.
* Multiple or repeated posting in order to increase your post count is not allowed.
* Advertising, spamming and trolling is not allowed. This includes using the forum email and Private message system to spam other members.
* We also do not allow posts that are sexual in nature.
* Please wait at least 24 hours before bumping posts.
* Discussion of illegal activities such as software and music piracy and other intellectual property violations are not allowed.
* Each member is allowed one login account. Registering with multiple accounts is not allowed.
* We reserve the right to remove offensive posts without notice.
* We also reserve the right to remove postings which are in violation of our specified posting rules
* Also, while these rules cover most common situations, they cannot anticipate everything. Consequently, we reserve the right to take any actions we deem appropriate to ensure these forums are not disrupted or abused in any way.
* You cannot post any affiliate or referral links, or post anything asking for a referral. Such posts will be subject to removal.
* You cannot post advertisements or notices for contests.
* We also reserve the right to ban anyone who willfully violates the forum rules, as access to our support forums are a privilege and not a right. A banned customer is still entitled to support from the support system, but will not be able to participate in the forum.
See more
See less

How are you updating prices?

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

  • How are you updating prices?

    We have price changes regularly in order to compete on today's web. Because we sell items that can ship as 1 gallon, 1 quart, etc, price changes for example of 100 items can take up to 6+ work hours.

    We have tried excel but the advanced options file does NOT include the item name making it practically impossible to do via excel unless you are an excel jedi which I am not.

    Do any of you have any suggestions on how to update pricing faster or if you know of any 3rd party tools that will edit the 3dcart exports?

  • #2
    I am not sure this is what you are looking for, but perhaps it will help https://support.3dcart.com/knowledge...editor-feature
    http://www.pack-secure.com

    Packaging and Shipping Supply Specialists

    Comment


    • #3
      I am aware of this tool. It only works for items that do not have advanced pricing. For example it will work if the SKU is 1 widget with no product options. However if the SKU can be shipped as 5 gallons (and a unique price for 5 gallons), 1 gallon, 1 quart, it does not work. And since the vast majority of our items do ship with different volumes, it makes price changes mind numbing slog.

      Comment


      • #4
        You can use their REST API: https://apirest.3dcart.com/Help/Api/...dvancedOptions

        Comment


        • #5
          I am not a coder.. is anyone aware of any 3dcart customer that has used excel macros to get this to work?

          Comment


          • #6
            Hi [email protected] - do you sell anywhere other than 3d? If so, we use a multi-channel inventory manager where we can change pricing on multiple platforms at the same time by making 1 change on its system, either manually or by way of spreadsheet. It is called ecomdash. I hope that helps.

            Comment


            • #7
              If you use the advanced part number field (AO_Sufix) or GTIN, you can use that as a lookup value in an excel document. I use excel's power query functionality to pull the data straight from my database. I added a macro to the file and a barely trained staff member can update all of my advanced option availability daily in about 15 seconds. I'm sure that you can do the same with pricing. So, one worksheet with your inventory information, one worksheet with your advanced options export data and a vlookup formula targeting the appropriate column(s). Here's a screenshot of the formula

              CapturFiles-201907183_190791.jpg

              Comment


              • #8
                @masssagestore, can you please advise me the name of that product you are using? Assuming you have to conduct the 3dcart exports and imports manually after you have used the tool?
                bzeltzer, thank you for the example.. I am looking for something out of the box that I can use immediately as I am not a coder.

                Comment


                • #9
                  Sure [email protected] it is called ecomdash. Very reasonably priced. Hope that helps.

                  Comment

                  Working...
                  X