Search Results - Volusion/Bigcommerce/3dcart Ecommerce Forums

Search:

Type: Posts; User: jmartyka

Page 1 of 4 1 2 3 4

Search: Search took 0.00 seconds.

  1. Interesting..you're doing these someplace I don't...

    Interesting..you're doing these someplace I don't so maybe that is it.

    I do them under Reports->Reporting.

    Then choose Create/Edit Report in the top right and change the top drop down to...
  2. I used to get an error like that sometimes and...

    I used to get an error like that sometimes and none of my reports would work in Volusion. Drove me nuts.

    Maybe its a formatting thing copying off here. Try using this unformatted version...
  3. Replies
    1
    Views
    625

    Cool idea. This will get you started...it...

    Cool idea.

    This will get you started...it doesn't do subtotal. It works off the total order value instead. I think subtotal had to be calculated which is more work. I couldn't get arrays to...
  4. What was the error? As it stands it gave me...

    What was the error?

    As it stands it gave me all coupon codes used last year on the site I tested it.
  5. The key part is you need to join the Orders and...

    The key part is you need to join the Orders and Customers tables together. I added those 3 fields you mentioned into your SQL above and tested it.



    SELECT
    OrderDetails.CouponCode, ...
  6. It could be related to that space that is showing...

    It could be related to that space that is showing up in the long line at the right end in ShippingMethodID. When I edit the post, the space isn't there.

    Or it could just be Volusion. I don't do...
  7. You need a COUNT(Orders.OrderID) in your select. ...

    You need a COUNT(Orders.OrderID) in your select. The following is what I had for the count and sum of shipping charged to customers.

    SELECT
    ShippingMethods.ShippingMethodName,
    ...
  8. Replies
    7
    Views
    1,597

    Took me less than 15 minutes to configure. I did...

    Took me less than 15 minutes to configure. I did already have an amazon seller account because of non-volusion things I do. I've had amazon payments on volusion running for 2 weeks. Around 5% of...
  9. Replies
    6
    Views
    1,116

    I don't see why you couldn't design a packing...

    I don't see why you couldn't design a packing slip based on what you want and then have custom forms printed that have stickers in certain locations. Easy to do in Shipstation with the custom form....
  10. People don't always visit your site and instantly...

    People don't always visit your site and instantly buy. AdWords doesn't track those other clicks such as SEO, pinterest or whatever...it doesn't have any way to know that someone clicked anything...
  11. Replies
    29
    Views
    8,518

    Google Chrome version 38 started pushing out in...

    Google Chrome version 38 started pushing out in the last 2 weeks and causing problems. We had some problems with our shipping software failing to communicate with the same problems as customers...
  12. I meant it for acquiring their customer lists and...

    I meant it for acquiring their customer lists and traffic, not for actually fixing their broken businesses. Keep the good, throw out the bad. It can be a good strategy to get a chunk of growth...
  13. Buy them out if you think it will turn around and...

    Buy them out if you think it will turn around and can weather the storm. If its painful enough for them, you may even be able to do leveraged buyouts and just pay them out of sales from their...
  14. Replies
    45
    Views
    5,481

    We switched to PayPal this year as well to handle...

    We switched to PayPal this year as well to handle everything. We have a bit more complex environment with 6 sites on 2 different ecommerce platforms.

    Everyone should have their rates examined...
  15. Replies
    4
    Views
    1,290

    Well neat, I got a notification that I can...

    Well neat, I got a notification that I can actually save SQL reports again.

    This should at least get you started if you still don't have it done.

    I rounded the line item sales tax. This won't...
  16. Replies
    7
    Views
    934

    Was the failing order the first order by the...

    Was the failing order the first order by the customer?

    We see this on a daily basis and have a process to validate all new customers with no orders...because we've only seen this occur on new...
  17. Replies
    4
    Views
    1,096

    SELECT Customers.CustomerID, ...

    SELECT
    Customers.CustomerID,
    Customers.EmailAddress,
    Customers.CompanyName,
    Customers.FirstName,
    Customers.LastName,
    ...
  18. Replies
    3
    Views
    997

    I installed one of the RFID timeclocks from...

    I installed one of the RFID timeclocks from uAttend.com I think it was the CB6000 (I'm not in the office this week). Easy to configure on the web interface.

    They support website and phone...
  19. If I recall from past conversations, some people...

    If I recall from past conversations, some people have different article IDs. It should go in the ROI Javascripts article. For my sites, Article 134 is an affiliate banners page.

    Also, just to...
  20. Replies
    2
    Views
    1,041

    Use the search on this site for "Order[2]" and...

    Use the search on this site for "Order[2]" and you'll get a lot of posts about setting it up correctly. Note that it is typically article 130, but not for all stores. That could be your problem.
    ...
  21. Replies
    7
    Views
    1,300

    If you go to Settings->Payment and have the...

    If you go to Settings->Payment and have the Payment Gateway tab selected, click on Alternative Settings (in orange just above FAQ).

    You can then choose:

    Authorize at Sale, Capture at Shipping...
  22. Replies
    8
    Views
    1,231

    What is the error message? Hmmm...looks like...

    What is the error message?

    Hmmm...looks like editing SQL is broken on all my sites. < and > are being converted to &lt and &gt which generates an error.
  23. Replies
    9
    Views
    1,388

    It is Products_Extended.ProductPrice And...

    It is Products_Extended.ProductPrice

    And you'll need to join that:

    FROM Products INNER JOIN Products_Extended ON Products.ProductID = Products_Extended.ProductID
  24. Replies
    8
    Views
    1,231

    Yesterday would be: DATEDIFF(DAY, GETDATE(),...

    Yesterday would be:

    DATEDIFF(DAY, GETDATE(), Orders.OrderDate) = -1
  25. I like the interface change. I don't like that...

    I like the interface change. I don't like that they broke shipping order by.

    I'm rather annoyed looking at it today that everything is now out of the order I had specified in the old system.
    ...
Results 1 to 25 of 77
Page 1 of 4 1 2 3 4