Search

Jordan,

Glad you got the reports working.  When you say the SKU is not showing up, do you mean on a report, such as an invoice?  If so, please email the template you are using to us and we will try it out here to see if we can figure out what is wrong.

Another thing you can look at is on the item details screen.  Is the item code being showed on the item list there?  To get to this screen just double click on an order on the main order list found at "View" | "Orders".

Thanks,
David

Rox,

As of the 1.1.2.2 beta it will check the order for whether tax was collected.  If so it will set the customer to taxable.  Otherwise it will default to non-taxable.

Thanks,
David

Jordan,

SuperManager report templates can be editted with any html editor.  There are several available, such as dreamweaver, frontpage and word that require little if any understanding of programming.  With these types of programs it is more like laying out a document.

The only key things to know about editting templates are the following:

1. Default templates are copied to C:\Program Files\SuperManager or wherever you install The SuperManager when it is installed.

2. Enter the order, address and billing variables shown in the appendix of the user's manual whenever you want a field variable inserted into the invoice.  The templates that come with The SuperManager will give you a good example to start with.

3. If you want item information to be substituted just create a table row and The SuperManager will automatically create a copy of the row for each item.  Again - use the default templates to see an example of that.

4. After you have completed your custom template add it to your store settings under "View" | "Store Settings" | "Reports"

If you have any detailed questions feel free to post them on the forum and we will answer them quickly.

Thanks,
David

Jordan,

Good question.  Someone asked me this just a couple days ago.  Good to get a chance to answer it on the forum where other users will hopefully find it useful.  SuperManager's printing features use Internet Explorer and therefore are dependant upon the margins you have set in Internet Explorer.  To set the margins to a value compatible with the invoice template:

1. Close The SuperManager.
2. Open Internet Explorer to any webpage and click "File" | "Print Preview"
3. Once the Print Preview comes up click on "Page Settup" (it looks like a gear in most versions)
4. Change the margins to 0.25 left and right and 0.50 top and bottom.
5. After doing this you can close the page setup and then the print preview.
6. Re-open The SuperManager.

Internet Explorer will remember these settings and apply them when you print from The SuperManager.

Thanks,
David

Nathan,

I misunderstood what you were wanting.  I thought you just wanted a variable code that clipped the product description to 40 characters to export for froogle.  What you really needed was another non-yahoo field that you could populate?  In the 1.1.2.2 beta I have added 2 custom variables.  You can use one for harm codes and the other for descriptions.  How does that sound?  We are alpha testing it now.  I will let you know when it is ready.

Thanks,
David

eyebug, Rox,

Would a good solution be to have SuperManager set customers whose order tax total is zero to non-taxable and those with tax to taxable or is it best to leave as is?

Thanks,
David

Nathan,

We are planning to add a limitted description field for you.  I just wanted to make sure - it is the description, not the caption that you want to have clipped, right?  From my experience the caption is generally the longer one.  I'm sure you could have descriptions longer than 40 characters as well.  Just wanted to make sure before releasing it.

Thanks,
David

Nathan,

Here is a link to the fraud detection product this company offers:

http://www.maxmind.com/app/ccv_overview

Let us know if you are interested as well.  The more people that are interested the higher the priority would be for our development plan.

Thanks,
David

Eric,

Thanks for pointing us to this.  We will consider adding support for minFraud.  It would probably be 3-6 months before we would be able to implement it due to other features that we are currently developing.  We will keep you posted.

Thanks,
David

Nathan,

What do the harm codes look like?  Do you have a list of them?  Are they just numbers?  A single letter?  A word or phrase?

Thanks,
David

Ben,

Glad that worked for you.  Keep us posted of any other questions or difficulties.

Thanks,
David

Rox,

Sorry to be slow to pick up on what you meant.  I knew we had gone over this issue before and I had forgotten the exact details of how it gets tripped up.  In the early versions we ran into a similar issue with adding discounts and adjustments in the favor of the customer.  We fixed that by having SuperManager put all total line items that favored the customer last so that the balance never went negative by virtue of a discount for example that would drive the balance negative before the tax was added.

The one quick fix solution that I can think of is to add all the credits to the customer first, then the charges against the customer last.  I really don't like this really because it puts the transactions out of chronological order, but it would be a pragmatic approach to make the entire transaction work in one single object, without having to use a check to counter balance an apparent overcharge.  We could try to restore order to the mis-ordered transactions by adding a date the transaction was made.

I just really hate how QuickBooks creates this problem by requiring the running balance to always remain positive.  What do you think of this idea?  Any other ideas?

Ben,

Sorry for the late reply - I've been on the road today.  I took the list you gave below and reformatted it a bit to look like I would expect the batches text file from Yahoo to look (still preserving confidential data):

Batches through FinnishGifts Merchant Account 1111111111

Code Select Expand


000002 at Aug 13 18:55:12
  Sales                        Invoice    Card                 Expiry     Approval   Amount
    finnishgifts-6981          3792887287  4100000000003797     11/2006    412043    $157.50
    finnishgifts-6982          3797678844  4700000000006420     7/2008     094918     $54.00
    finnishgifts-6983          3798055737  5400000000007706     5/2007     152593    $312.08
    finnishgifts-6984          3798774883  3700000000001001     7/2007     111503    $152.00
    finnishgifts-6985          3803648644  5400000000000315     2/2008     083814    $146.00
    finnishgifts-6986          3803444427  4100000000009374     4/2009     002493    $131.00
    finnishgifts-6987          3809787503  5100000000009160     9/2007     243363    $207.00
    finnishgifts-6988          3811644050  5500000000005342     1/2009     075381    $228.00
    finnishgifts-6989          3812193101  5400000000000791     10/2007    003498    $118.75
    finnishgifts-6990          3814181484  4300000000000578     11/2006    051538    $197.00
    finnishgifts-6991          3814977146  4300000000002733     3/2009     024823     $43.00
    finnishgifts-man-FS16302   3109        4300000000001929     09/2009    195279     $56.00
    Total                                                                          $1802.33

  Credits                      Invoice    Card                 Expiry     Approval   Amount
    finnishgifts-6798          3107       4300000000001559     6/2009                $39.25
Total  1 for 39.25


When I imported it in this format it worked.  Here is what you probably need to do:

1. Go to your desktop and click on "My Computer" to bring up windows explorer.
2. In the "Address" box type "%temp%\SuperManager".  This should take you automatically to your windows temp folder SuperManager directory.
3. Open the file "batches.txt" in notepad.
4. Search for the batch you had problems with, "01495".
5. Look at the third entry in the list and see if it appears as it is above.  Do you see something that looks a bit different?  The most likely culprit is in spacing (or lack thereof).  Yahoo sometimes does not put a space between the order number and the invoice number.  When this happens The SuperManager does not know where the space is supposed to fall.
6. If this is the reason and add the space to the entry where it belongs (or at least where it looks like it might belong since there is no for sure way to know).
7. In The SuperManager go to "File" | "Import" | "Yahoo!" | "Batches File" and choose the file you have just fixed.

I beleive it will import for you then.  My experience has been that these type of errors are not very common.  You may run into similar problems with other entries that you will have to fix in a similar manner if they appear.  After they are imported you will be able to import future batches as long as they don't have the same problem.

Please let me know how it works out.

Thanks,
David

Rox,

The SuperManager correctly exports most receipts as long as they are correctly reconciled in The SuperManager.  There are some particular cases where it has problems, but those are rare.  For the most part it is just important to have orders correctly  moved to "Charged"/"Paid" status and make sure that the order details do not show that the customer has paid more than was due.

The SuperManager automatically changes them to "Charged"/"Paid" status when the amount received from the customer equals the amount due.  On the order details page the box in the middle of the page shows the subtotal of all items, any special case charges such as giftwrap, discounts, coupons and tax followed by a final total.  This final total is the amount due.  The amount received from the customer is detailed by the sum of all the "Charge". "Manual Charge", "Paid" and "PayPal Payment", etc... events minus any "Credit", "Return", etc... events.

If an order is not set to "Charged"/"Paid" status you probably need to add an additional payment event to show that the customer paid the full amount due, change the price of one or more items to show what you really charged the customer, add a discount that you gave, reduce the shipping amount, etc... to justify why the order is actually paid in full.

All this said, this is not what causes "Receipt balance cannot be negative" errors.  These are caused by the opposite problem in the orders - the order shows that you have received more from your customer than the amount due.  To resolve this you generally need to increase the cost or quantity of one or more items, increase the shipping amount, add an additional total line item or other such action to justify why less was required of the customer.  Once the amount due is not less than the amount received you should be able to successfully export the order(s).

Thanks,
David

Nathan,

I just had an idea that I think will work for you.  It involves using product variants and alternative product codes.  What you should do is:

1. Create all variants for these products by going to the product screen, selecting these items and choosing "Actions" | "Create All Variants" from the menu.

2. After doing this when you go into the product details screen you will see two or more variants in the list at the bottom left corner of the screen.

3. Select each of these and enter an "Alternative Product Code" in the box on the bottom right of the screen.

4. Create item groups in QuickBooks with the names you entered in the alternative product code.  You can create one called twin_pack_express and twin_pack_ground for example, one with the two items and a shipping item for express shipping and likewise for the ground shipping.

If there is a product variant that matches the option combinations in the item in an order, when the supermanager exports the order to quickbooks it will use this alternative product code if one exists, otherwise it uses the default name.  Let me know if you need further explanation.

Thanks,
David