[Moe]

I pointed this out to the tech team mid of 2019, and got nowhere.

They do get copied and imported in the new account database but they are linked to no account, “SellerAccountseBayID 0” which doesn’t exist anywhere. So they won’t show.

If you are an advanced user, here is the solution:

– Install Microsoft SQL server manager.Studio.
– Connect to your destination database.
– Go to ShippingTemplates table and edit SellerAccountseBayID column and change the values from 0 to 1 (1 is your first eBay account ID registered within sixbit) it could be a different value if you have added multiple eBay accounts.
– Reopen sixbit, and they will all be there.

Also make sure if you have created shipping rate tables from eBay. to remove the values in the ShippingTemplates table.

Cheers.

 

[Moe]

nevermind, I just saw them in the Stable Release..!

[Moe]

Do you have the Beta Release Notes for 4.00.017 / 0.18 / 0.19
I only see the latest 0.15

[Moe]

It doesn’t. we’d love to have that future implemented!

[Moe]

Troy wrote:

it seems that the SixBit application  doesn’t like to look at DNS names like db.ourfakesixbitserver.com or straight IP addresses 12.210.24.211 in the configuration panel

It does,  it really has to do with opening the required ports to your specific machine, and routing protocol in general.

You need to troubleshoot the cloud server to allow that.
You can start by disabling temporarily the firewall, and make sure that specific port for MMSQL is assigned.
Hope to hear your thoughts once successfully connected, and how reliable it is.

 

[Moe]

Troy wrote:

I have allowed access from our external IP range

I have done many tests on this, I concluded that running SB remotely, where it has to communicate “directly” on WAN is sluggish.

Best is to let SB software communicate with the SQL server on LAN, and then you remote directly to the SB software/machine, you can use RDP or some other software.

If you are renting a cloud SQL machine, this would not work for you, as you do not own a dedicated machine, where you can install SB on it, along with SQL server. For more detailed info, you can check my post under Selling Strategies

Back to your question:
Have you created a static port on your SQL machine, and allowed inbound connections to that port?
You can find it in SQL configuration manager > SQL server network configuration > Protocols for (instance db)  > TCP/IP > IP Address > IPAII > >TCP Dynamic Ports > (you need to set a unique port)

then Allow connections access to that port it in the firewall, but since you mentioned, you allowed all ports/connection to your specific IP, you should be fine.

[Moe]

Thank John, that list is not comprehensive.  But I did some digging on google, and found them:

Wildcard Characters in SQL Server:
Symbol     Description                                                                     Example

%                Represents zero or more characters                               bl% finds bl, black, blue, and blob
_                 Represents a single character                                          h_t finds hot, hat, and hit
[]                Represents any single character within the brackets   h[oa]t finds hot and hat, but not hit
^                 Represents any character not in the brackets               h[^oa]t finds hit, but not hot and hat
–                  Represents a range of characters                                     c[a-b]t finds cat and cbt

All the wildcards can also be used in combinations!
Here are some examples showing different LIKE operators with ‘%’ and ‘_’ wildcards:

LIKE Operator                                          Description
WHERE CustomerName LIKE ‘a%’       Finds any values that starts with “a”
WHERE CustomerName LIKE ‘%a’       Finds any values that ends with “a”
WHERE CustomerName LIKE ‘%or%’  Finds any values that have “or” in any position
WHERE CustomerName LIKE ‘_r%’     Finds any values that have “r” in the second position
WHERE CustomerName LIKE ‘a_%_%’ Finds any values that starts with “a” and are at least 3 characters in length
WHERE ContactName LIKE ‘a%o’ Finds any values that starts with “a” and ends with “o”

This would be nice for the average Joe/Jane to know this
I find it very powerful for people who needs to quickly filter their grid. Specially the [^] symbol.

Cheers.

[Moe]

Good Point Matt. It is insecure when opening 3389 to the public. I personally was a victim of a ransomware, it spread all over the network. Every file was encrypted! but luckily a backup system was set in place, and I’ve restored my important files.

That’s when I start digging on how to secure RDP. It’s complicated to explain, but these are essential in my PoV:
1- Windows Firewall: you got to block port 3389, 135, 445
2- Use a Gateway Server and only allow 443 for incoming connections.

[Moe]

THANK YOU JOHN.

[Moe]

You need to open port 3389 TCP and UDP in your router. This will allow incoming connections to your RDP from the Internet.

[Moe]

just stop, and disable sixbit agent to prevent it from running until you are ready and want sixbit to do its refresh in the background.

[Moe]

Noticed This has been resolved in the latest beta release. Thank you!

[Moe]

Is this a Sixbit related issue? I doubt it.
Monitor your network activity in Resource Monitor, and see what software is using your data under send/receive.

[Moe]

I agree on having a Main category for returns,

The way I get around this, is to create subcategories under fulfilled, for each step you desire to have, and move the orders from one sub to another…
But what sucks is that you need to go to eBay and follow up for each order and see the updates, which gets overwhelming sometimes.

[Moe]

it is NOT a requirement to have sixbit installed on the same SQL server.

I’ve read all the documentation on the site and it all says you must have SixBit installed on the SQL server. Yet there is always this nebulous comment about you can run it on a “web server”.

[Author]

Posts