Messages

1

Help Us Build the Database / Re: anyone want to scrape UPC #s?

March 28, 2021, 12:52:11 AM

.... I'm starting to have my doubts about using the data from this site. I wonder if some of them are just made up for a store's inventory purposes.
I thought I'd start getting #s from exclusives, and was getting them for BotCon products, but where would they get such #s? There's no UPC # on the bags, and I found a box that FunPub had used for one souvenir set, that while it had a SKU #, it didn't have a UPC #. Unless it was a smaller box from within a larger box, and only the larger box had the UPC #. Although I'd be surprised it wasn't more widely used than that. Considering how amateurish their forum was, perhaps they didn't use UPC #s to track inventory and only did it manually.

2

Help Us Build the Database / Re: anyone want to scrape UPC #s?

March 23, 2021, 12:34:53 AM

Sorry, I think the URL got chopped off somehow. Is this the same site you found?
https://www.upcitemdb.com

I had manually entered one UPC # we didn't have. I wonder if I should manually scan through some of the rarer Transformers or just leave the task of scraping it up to you.

I bought a wireless barcode scanner to help organize my collection. I don't know if there's a point in making barcodes for individual loose figures since I'd have to do it all manually, but I was considering that. Maybe it would only be worthwhile if I were doing a lot of buying and selling of loose figures.

3

Bugs? On www.shmax.com? Ha ha, you kill me... / Re: Edits are BACK! ...but...

March 13, 2021, 08:53:17 PM

Chaotic Descent, I still don't quite understand. You're saying that you can't add those items to your collection, but I visited a few of your pages and you DO have them. Do you mean that you can't add a second item? What would be helpful is if you can explain this to us with detailed steps. For example:
1. Go to this page https://www.shmax.com/product_details/5805/heatwave
2. Confirm that there are no items from your collection listed under the "Your collection" section of the right sidebar.
3. Click "Add to my collection"
Expected result:
- a blue bar representing a collection item appears
Actual result:
- no blue bar appears

Something like that would help. Thanks much.

Correct. Despite it showing up in my collection results, there is no blue bar like there are for other items in my collection.
Clicking on "add to my collection" does not show any indication on that page that anything has happened. No blue bar like with other items. Other items work normally both before and after, so it's not like my login is timing out at any point.
.... it DOES seem to be adding it.... because now I have two Heatwaves listed in my collection results. and I can remove them from that "collection" result page, via the mouse-over option "delete" on the right side. "details" works, but "edit" does not.
I don't know. It's hard to figure out what it is or isn't doing. I tried to add a 2nd Breakaway, and it didn't show a 2nd one in the collection results. I deleted it, and THEN it let me add two. but it still doesn't have the blue bar, so I can't edit it to be loose or anything.
https://www.shmax.com/part_details/29435/nexus_maximus
It has blue bars that I can edit for the other 3 members, but not the 2 glitched ones. It's like they have write-protection on them or something.

Chaotic Descent, which browser are you using?

MIKE
engledogg

Firefox. 85.0.1 for Ubuntu.

4

Bugs? On www.shmax.com? Ha ha, you kill me... / Re: Edits are BACK! ...but...

March 13, 2021, 03:16:31 PM

I'm running into a problem of specific items not being able to be added to my collection, while others on the same page are able to be. Going to the page for the item, (as opposed to trying to add in in a search result list) doesn't change this. I can add them to my wishlist.
So far I've run into these old items:
https://www.shmax.com/product_details/933/omega_spear
https://www.shmax.com/product_details/4581/alpha_spear
https://www.shmax.com/product_details/5805/heatwave
https://www.shmax.com/product_details/4902/breakaway
https://www.shmax.com/product_details/5914/nightbeat_shattered_glass

Strangely enough the other 3 figures from that old TFCC Energon gestalt CAN still be added. Coincidentally (?) those are two that were already listed in my collection. That's suspicious (because I'm fairly certain I've had the whole set for a long time and didn't leave the database mid-way through release), so it's possible they've been taken off my collection.

So, when you say you can't add something to your collection, what exactly do you mean?

When you click the "add to my collection" link on each of the product records, what happens?  Does the blue UI bar appear?

MIKE
engledogg

Nothing at all happens.

5

Help Us Build the Database / anyone want to scrape UPC #s?

March 13, 2021, 08:46:35 AM

I found a website that seems to archive UPC #'s that might be useful for here.
itemdb.com
I don't know how to code something to scrape the data and send it here, but they do provide the means on their end to do so, 100 entries a day for free. I'm sure there are ways to get around that, although I'd worry that exploiting that might eliminate the free service completely.
It looks like they in turn have been scraped from other stores and auctions (as their product names sometimes have odd words like "loose" chosen as the 1st result out of many) and they don't have ALL Transformer products, but they do have a surprising amount of old and obscure stuff that might not be here.

6

Bugs? On www.shmax.com? Ha ha, you kill me... / Re: Edits are BACK! ...but...

March 13, 2021, 08:36:41 AM

I'm running into a problem of specific items not being able to be added to my collection, while others on the same page are able to be. Going to the page for the item, (as opposed to trying to add in in a search result list) doesn't change this. I can add them to my wishlist.
So far I've run into these old items:
https://www.shmax.com/product_details/933/omega_spear
https://www.shmax.com/product_details/4581/alpha_spear
https://www.shmax.com/product_details/5805/heatwave
https://www.shmax.com/product_details/4902/breakaway
https://www.shmax.com/product_details/5914/nightbeat_shattered_glass

Strangely enough the other 3 figures from that old TFCC Energon gestalt CAN still be added. Coincidentally (?) those are two that were already listed in my collection. That's suspicious (because I'm fairly certain I've had the whole set for a long time and didn't leave the database mid-way through release), so it's possible they've been taken off my collection.

7

Feature Requests/Announcements / Re: is there a faster way to update collections?

September 27, 2011, 09:46:23 AM

I'm just curious, CD...what kind of computer/internet connection are you using?

MIKE
engledogg

My PC is old, but since when do you need to buy a new computer every 2-3 years just to browse a database on the internet? It's not like cutting-edge tech for gaming. It's a P4 3GHz with 1GB of RAM.
I'm on cable internet,  but it seems like all ISPs are meddling with the connections, preparing for tiered internet. so... there's no real guarantee that highspeed internet is high speed.

8

Feature Requests/Announcements / Re: is there a faster way to update collections?

September 27, 2011, 05:09:36 AM

Thanks, CD, that helps clarify things quite a bit. The second mock-up is right out--there are toys in the database with a hundred parts or more, and it just doesn't work.

Well why not just have the website decide a threshold for when is too much? If it fits on the page, display checkboxes.

Even ones with hundreds of parts could include the base figure and box/instructions, since those would be most common.
Or for figures with more parts than can fit on the page, have a single checkbox for them all. If you have them all, this speeds things up. If you're missing most of them,  it still speeds it up to uncheck them all and then load the drop-down to pick the ones you do have.

Concealing the part list in a hidden pop-up that flies out when you click a "parts" button is better, but then we're right back to a big expanding area, which you don't like.

Well, it would also hopefully be smaller with just the parts list.
It also wouldn't be necessary unless you needed clarification on the name/appearance of the 3rd weapon,

or if like I said above, you still had the checkboxes for figures with fewer parts, or for the first few parts if they don't all fit.

If I follow you, you're troubled by the fact that when you click a collection row in our current model, a big area appears and expands the page, which means you have to scroll down to get to the next row. Two questions: first, can you not minimize the scrolling headache by just clicking the header again to close the UI?

Yes, but whether you scroll or minimize, it's action that delays updating. Each click, scroll, or new window requires work with your hands and eyes and brain to rescan what you're doing, even if it's the same thing. I actually find the pull-down menus hard to memorize (so I don't have to rethink what I'm clicking each time) because they're not in the same spot each time, and don't scroll parallel to drop-down. The condition when bought and currently also overlap. It's just a big mess.

Second, would it be an improvement if the entire collection UI we have now still expanded, but appeared as an overlay on top of the page, so that no "scrolling" happens?

Hrm. I wonder how that would help... Like if I clicked to expand the one below (which would require the overlay not to block/cover the button to open the one below) while the one above was still open, it would switch? I think that would only be a minor improvement.

Overall, I think you have some good points, and I'll see what I can do when I get around to reworking the "Your Collection" page. One possibility would be to have a "Compact mode" link somewhere near the top, which would switch the view to something like what you describe. But that'll be a long time coming. In the short term, we can try replacing the condition drop-downs with radio buttons. But first I need to take a few days off... my brain hurts.

Yeah. Options are good.

I've checked with my collection, at the top level the fun facts stayed below the 0.7sec mark.  About this I'd be an advocate that every fun facts should be visible at first glance.  If you need to scroll to see the end, there is too much displayed.

The top performance hog feature right now would the item count displayed between () in the tree navigation.  It counts for about 40% of the load time.  On the next iteration of the navigation process, we'll to carefully evaluate the benefits / costs for it.

I just want the option of disabling the whole sidebar, not that it's removed for everyone forever.

I don't need to be updated on that every single page I load while I'm editing my collection. I'm spending my time and mental energy updating my collection. If I WANT to constantly compare my collection to others, or be updated on my stats, I want that to be up to me. I did find it useful to bring down my most valuable item to one that was accurate, although my opened BotCon Darkside Megatron is worth more than my busted up G1 Fort Max. It's worth about as much opened as loose anyway. Crazy.


Also, you could fit more on the page width-wise if you could also toggle the visibility of the browse category window on the left as well. It's useful to have, but if you're going through pages of entries... hrm. Who knows. Perhaps with this more brief listing format, you could fit most series on a single page anyway.

9

Feature Requests/Announcements / Re: is there a faster way to update collections?

September 19, 2011, 09:30:37 PM

It wasn't really deliberate--I think it's just a result of the way we gradually gained features piece by piece. You're an old-timer, so you may remember back when the "Add to my collection" was just a checkbox.

So there you go, we wound up with something that is well-meaning but maybe a bit klunky. I'm totally willing to redesign it, but there are other major projects already in the works.

Yup. I understand.

Also, you wouldn't have to include the descriptive text for the radio button for each figure entry, since they'd be in rows/columns.

I'm having a little trouble getting a visual. Care to whip us up a mock-up in Photoshop (or Paint, or crayons)? We don't mind if it's crude.

Sure.
Bleh. I think I spent more time on that than I needed to.

Here's a couple versions. The one with 2 rows makes better use of space, allowing room for parts checkboxes, but I guess it's more difficult to read, especially the headers.
Maybe it's just because I rushed the design. Maybe it wouldn't work. Maybe it would. You could have a [mouse-over / pull-down] on the header to show [the full text / a diagram (text + example box outlines)] for a specific column.

Hopefully you can dynamically adjust how many checkboxes it shows for each figure entry. If not, I suppose try to include the average maximum, and just cancel any checks for invalid accessories.

I know that kind of complicates things but... that's what the drop-down "(more) parts" button is for, if you want to see the detailed text. Ideally you have some checkboxes so that you don't HAVE to click that every time you want to specify accessories/parts that differ from the default. You might think "well, if it's not the default, it's not that common." but that's not necessarily true. Most of my figures are loose or opened. Some people mostly have sealed figures. Some people might have each half of a large collection as either.


(Also I forgot to add the image link in the first example.)

and for some reason it's resizing the images, although that seems to be your forum, as right-click->"view image" they're full size.

Hopefully the whole thing would fit on a page that would eliminate the need for scrolling.

I don't quite get this one. If scrolling bothers you, why not just set the "Items Per Page" to something you can live with? It goes down to 10 items, and your choice will be remembered from page to page.

Because with the pulldown for a figure covers an entire page, so I have to scroll (or click again to close it) each time anyway. It doesn't really save me any time.

Perhaps if a rapid succession of edits would slow down the system, it could be changed to save up a batch of these edits at a time when in this quick-edit mode?

Well, we already are doing this. When editing a collection record via the UI, you may have noticed that the "Auto-save" doesn't fire until you've stopped fussing with it for a few seconds. I wasn't aware of any lag when doing saves, and even if it does lag a bit, there's nothing stopping you from moving on to the next record while you wait.

Ah ok, so the current setup would work with this. I was worried I was suggesting a method that contributes more of a burden on the system. No problem.

10

Feature Requests/Announcements / Re: is there a faster way to update collections?

September 19, 2011, 10:45:06 AM

Why is that listed in a different section and in a different way from the instructions?

I don't follow.

I mean why is the box not considered one item as a content of a theoretical product and listed along side "instructions", rather than thought of as a basis for the product, even though it can potentially be excluded from the collection?
I mean, I guess perhaps it's to avoid the possibility of having all the items checked as not being included, which means you  have nothing, which means that entry should not exist? Maybe it's kind of complicated to code conditions for having it delete the entry or require you to have one of the items checked off.

It's strange to think of the packaging as being a part of the condition of the item. I mean, it is when it's unopened, and you can't have an unopened figure without the packaging... but on the other hand, when opened they're completely separate issues. (You can have QC issues that result in an unopened figure being worse than an excellent condition opened one. Either a production error with assembly or paint, or paint wear from the packaging. Sometimes chrome flaking, metal oxidizing, batteries leaking.

I noticed at one point the most valued item in my collection was Fortress Maximus, even though mine has his thighs broken and mended with spare plastic sheets from another toy and a rivet gun. I have to imagine that's pretty worthless, but I can't change a setting to fix that, other than to remove it from my list for not being good enough to count.
(Now I'm just rambling.)

The only thing I can think of is that using Radio buttons for condition will take up more space for that particular choice. I don't know whether or not there would be a significant increase in time for making a change tho.

Well, it would be counteracted, since my suggestion was to pair it with a more brief listing that lacked images (or perhaps a link to the images so you could have quick reference to them when you weren't sure, but without having to load them all).
Also, you wouldn't have to include the descriptive text for the radio button for each figure entry, since they'd be in rows/columns. You could just stick a header on it. Hopefully the whole thing would fit on a page that would eliminate the need for scrolling.

BTW, I don't know if it's just me that's getting lagging interface, but perhaps the sidebar ("Fun Facts for Chaotic Descent's Transformers collection") on the right side also requires time to interact with the database to pull up those stats and display.
If so, is there a way to make it a pull-down (or pull-"side"?) menu that will not take resources until you click to open it? Just an idea.

I don't know whether or not there would be a significant increase in time for making a change tho.

You mean timing as far as the webpage and database access? From the user point of view it definitely would help. I'm sure it more than doubles if not triples or more the time it takes me to update a single entry.
Perhaps if a rapid succession of edits would slow down the system, it could be changed to save up a batch of these edits at a time when in this quick-edit mode? Perhaps don't do anything until the user clicks on another page and then contribute everything on the page? Or would that significantly slow down when the user could load another page?

11

Feature Requests/Announcements / is there a faster way to update collections?

September 18, 2011, 03:02:21 PM

(Sorry to only come on here to ask for more features to be implemented. I haven't been on this site in months if not years.)

TL;DR: Could we have an edit mode without pictures or pull-down menus? Just text and check-boxes/radio-boxes so you can quickly go and update a few dozen entries, each with a single click rather than multiple clicks on a sluggishly scrolling page.

One click to open the drop-down menu for the figure, another to click the drop-down menu for the condition, a second to recognize what to click on (no matter how many times you do it. I actually get worse at it with time since it makes me so sleepy.), another click to select it. Repeat the click-scan-click process if you bought it new but opened it.
All the while scrolling down the page. For some reason it doesn't scroll so smoothly, especially when first loading. I'm guessing that's because of all the work it does when it interacts with the database. Maybe being able to quickly edit a person's collection would be too much work on the system.

One of these days I'm going to learn SQL and stuff and be able to code some neat collection visualization options like what I've imagined since over 10 years ago. :|

BTW, what is the difference between "opened" and "loose"? Is that basically whether the box is included? Why is that listed in a different section and in a different way from the instructions?

12

Help Us Build the Database / Re: Customs?

March 07, 2010, 11:36:32 AM

yes

13

Help Us Build the Database / Re: Customs?

March 05, 2010, 09:34:30 PM

I don't understand what "creations of an arbitrary nature" means.
All I know is that often I remember a repaint by the mold it used and character it was repainted into, but not exactly what it looks like or who did it. Not knowing who did it makes it hard for me to find the picture in my files so I can see what it looked like, or upload it to show other people.

Yes, it is important to keep track of more than just repaints, like using parts from other figures.

14

Help Us Build the Database / Re: Customs?

March 01, 2010, 05:46:07 AM

I really should have learned databases years ago...

Right then... I guess I'll just do a table from scratch and hope it's not all redundant work when it comes to an end product.

15

Help Us Build the Database / Re: Customs?

February 28, 2010, 12:15:45 AM

This thread probably belongs in the "suggestions" forum (maybe?), but me and Skullgrin have mentioned this before, that we'd like to have a customs database. (Any update on this?)

Is there a way we could do data entry for it in advance, and be able to merge it with the database later? Will it be able to match entries with the current data from the download options, or will there be conflicts? It'd be nice if it dumped the unique ID#s with that, but I guess that would be a developer-only purpose.

BTW, do you know any data-entry programs that make it easier to enter the same data over and over? It really sucks in a spreadsheet editor when you have to copy&paste many times, rather than just say, "ok, all of these are by one author until I tell you otherwise". It feels so archaic. I tried to do a search for such a thing but I suck at finding things I know little about.